DB Link Between Two Databases in Oracle APPS

Here in this post we will discuss on how to create a DB link between tow Databases in oracle apps

This below code snippet will create a DB Link between the schema that you are running this query from and the host database mentioned in the script and 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';    

once this link has been created, you can access the objects of one database form another referencing the db link name.

for example:

          INSERT INTO xx_emp_table@dev_db

             SELECT *

               FROM xx_emp_table;

For any suggestion or issues with the above code, please leave your comments. I will try to reply back as soon as possible