如何使用DBLINK

查询是否有创建dblink的权限

select * from user_sys_privs where privilege like upper(’%DATABASE LINK%’);

登录到sys用户下面授予相应权限

grant CREATE PUBLIC DATABASE LINK,CREATE DATABASE LINK,DROP PUBLIC DATABASE LINK to local_username;

创建DBLINK

create public database link orcl_lk
connect to user_name identified by password
using ‘(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = orcl)))’;

远程查询

select * from act_ru_task@orcl_lk;