DBlink 생성

CREATE [PUBLIC|PRIVATE] DATABASE LINK dblink_name
CONNECT TO dbid
IDENTIFIED BY dbpassword
using 'sid';

 

ex)

CREATE PRIVATE DATABASE LINK USRAHMS.WORLD
CONNECT TO USRAHMS
IDENTIFIED BY USRAHMS01
USING 'ND_13_1';

create database link EKPLOGIN.WORLD
connect to WEBADM
identified by WEBADM
using 'ND_31';

강신윤 홈피에서 퍼왔어요..