Oracle dblink 생성 - TNS 정보로 생성

CREATE PUBLIC DATABASE LINK PRD_ODSDB_LINK 

CONNECT TO system  IDENTIFIED BY "welcome1" USING '  (DESCRIPTION = 

    (ADDRESS_LIST = 

      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.xxx.xxx.xxx)(PORT = 1521))

    )

    (CONNECT_DATA = 

      (SERVICE_NAME = ODSDB)

      (SERVER = DEDICATED)

    )

  )' ;

select * from tiger.table1@PRD_ODSDB_LINK;