DB Link How-To

생성하기
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;