0
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)))';
CREATE DATABASE LINK remotedb CONNECT TO
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)))';
0Awesome Comments!