생성하기
create database link (link_name)
connect to (user_id) identified by (password)
using '(tns_name)';
ex)
tnsname = 'dev'
user = scott
password = tiger
SQL> CREATE DATABASE LINK DEV_DB
2 CONNECT TO scott IDENTIFIED BY tiger
3 USING 'dev';
사용하기
ex)
SQL> SELECT * FROM tab@dev;