Thursday, 4 December 2014

Database Link creation using Oracle Description

Syntax :
CREATE DATABASE LINK remotedb CONNECT TO IDENTIFIED BY USING '(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = portno)) (CONNECT_DATA = (SERVICE_NAME = Servicename)))';

Example :
CREATE DATABASE LINK "INFADB" CONNECT TO data IDENTIFIED BY Lucid2014 USING '(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.168.104)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = INFOMRATICA)))';

No comments:

Post a Comment