Oracle Application DBA
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.
‹
›
Home
View web version
No comments:
Post a Comment
Note: only a member of this blog may post a comment.