database link

tnsnames.ora

DEV =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dev)(PORT = 1521))
    (CONNECT_DATA =
      (SERVICE_NAME = DEV)
    )
  )

일반유저에 권한 부여

GRANT CREATE DATABASE LINK TO ID;

생성 및 결과 확인

sqlplus id/password

CREATE DATABASE LINK DEV CONNECT TO USERID IDENTIFIED BY PASSWORD USING DEV;

SELECT * FROM TAB@DEV;

삭제

DROP DATABASE LINK DBLINKNAME;