R12.2 Apps DBA. Powered by Blogger.

DB Link Between Two Databases in Oracle APPS

No comments :
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.