[Oracle] Oracle DB Link Script

Oracle DB Link Script

CREATE  DATABASE LINK "DB_LINK_명"
    CONNECT TO "접속사용자명"
    IDENTIFIED BY "접속사용자패스워드"
    USING
          '(DESCRIPTION =
               (ADDRESS_LIST =
                   (ADDRESS = (PROTOCOL = TCP)(HOST = 아이피 및 도메인)(PORT = 포트))
                )
                (CONNECT_DATA =
                    (SID = SID명)
                )
            )'
   ;
   
   
   CREATE DATABASE LINK "DB_LINK_ORA"
    CONNECT TO "user"
    IDENTIFIED BY "userpass"
    USING
          '(DESCRIPTION =
               (ADDRESS_LIST =
                   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1522))
                )
                (CONNECT_DATA =
                    (SID = ora)
                )
            )'
   ;
   
   
   -- DB LINK 조회
   SELECT * FROM DBA_DB_LINKS ;
   
   -- Drop Db LINK
   DROP DATABASE LINK "DB_LINK_ORA";