Oracle - DB Link

농부지기 2017. 1. 21. 14:55

[ Oracle - DB Link ]

CREATE PUBLIC DATABASE LINK "Link명"
CONNECT TO DB이용자ID
IDENTIFIED BY "DB이용자비밀번호"
USING '(DESCRIPTION =
                 (ADDRESS_LIST =
                        (ADDRES = (PROTOCAL = TCP)<HOST = 원격DB IP)(PORT = 1521))
                 )
                 (CONNECT_DATA =
                       (SERVICE_NAME = 원격DB SID)
                 )
             )';

저작자표시 (새창열림)