Oracle - DB Link

[ 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)                  )              )';