Creating Database Link in Orale 11G or 12c Database?

Creating Database Link in Orale 11G or 12c Database?


Before creating DB link first verify  remote database TNS name details are added into your database tnsnames.ora file.

VIS =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.46.128)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = VIS)
    )
  )






Example:  CREATE DATABASE LINK db_link_name CONNECT TO remote_db_username IDENTIFIED BY remote_db_password USING 'remove_db_sid';



CREATE DATABASE LINK appsr12 CONNECT TO apps IDENTIFIED BY apps USING 'vis';