DB Link Between Two Databases in Oracle APPS

The name of the db link is 'dev_db'.
CREATE PUBLIC DATABASE LINK
dev_db
CONNECT TO
apps
IDENTIFIED BY
apps
USING 'HOST:PORT/SID';  
Example:
INSERT INTO xx_emp_table@dev_db
SELECT *
FROM xx_emp_table;

No comments:

Post a Comment

Note: only a member of this blog may post a comment.