오라클-DB LINK 설정

maddog.kang.com(로컬 DB)의 tnsnames.ora내용

PIRUKS =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.102)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = PIRUKS.KANG.COM)
    )
  )

--생성(선행 : tnsnames.ora에 등록)
CREATE DATABASE LINK scpdb
     CONNECT TO qisuser IDENTIFIED BY dlatl_02 USING 'SCP';
--테스트
SELECT * FROM QUAL_KSM_FROM_QIS@scpdb;