ORACLE 创建DBLINK

查询当前用户是否有DBLINK相关权限

SELECT * FROM user_sys_privs WHERE privilege like upper('%DATABASE LINK%');

如果没有，赋权

grant create public database link,drop public database link to 用户名;

创建DBLINK

create public database link DBLINK名
connect to 远程用户名 identified by 密码 
using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)
(HOST = 远程ip)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = 远程服务名)))';