DB Link Script

CREATE DATABASE LINK one_next
 CONNECT TO apps-- User Name 2 nd Db or Instance
 IDENTIFIED BY apps-- pwd  2 nd Db or Instance
 USING '
 (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 122.166.245.174)(PORT = 1620)) )
    (CONNECT_DATA =
      (SERVICE_NAME = prod)
    )  )';

after creating Db Link Access The 3rd party Ex: select * from oe_order_headers@one_next


Ur's
AmarAlam