Find

Oracle Example Create Database link (DB link)

CREATE  DATABASE LINK "ABC_TEST"  CONNECT TO "APPS"
    IDENTIFIED BY "secure1234"
    USING
    '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.123)(PORT=1523))(CONNECT_DATA=(SID=ABC)))'

-------------------------------------------------------------------------------------------------

CREATE  DATABASE LINK "APPS_TO_APPS"  CONNECT TO "APPS"  IDENTIFIED BY "APPS"  USING  '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.11.32)(PORT=1521))(CONNECT_DATA=(SID=SSS)))'

---------------------------------------------------------------------------------------------------
Posted by