DB 링크 생성

ORACLE DB 링크 생성

CREATE DATABASE LINK [DB 링크명]
CONNECT TO [ID]
IDENTIFIED BY [PASSWORD]
USING '(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = [SID])
    )
)';

 

예시 

CREATE DATABASE LINK TESTDB
CONNECT TO TEST
IDENTIFIED BY "1234"
USING '(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
)';

 

※비밀번호는 "" 감싸줘야합니다