ORACLE DB LINK 걸기

1. 서버현황

DB IP :

접속PORT :
SID :
USER :
PASSWORD :

 

2. DB Port 접속 여부

 

3. TNS설정
/oracle/102/network/admin/tnsnames.ora 
DBLink_name =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = sid_name)
    )
  )

4. DB Link 생성
CREATE DATABASE LINK "DBLink_name"
CONNECT TO "유저아이디" IDENTIFIED BY "유저암호"
using 'DBLink_name'

5. DB Link 생성여부 조회
select * from all_db_links;

6. DB Link 테스트
select * from [table명]@DBLink_name;