--查看是否有dblink权限
--select * from user_sys_privs t where t.privilege like upper('%link%');
--没有就开权限 (使用root)
--grant CREATE PUBLIC DATABASE LINK,DROP PUBLIC DATABASE LINK to 用户名;
create public database link link_name
connect to 要连接的用户名 identified by 该用户的密码
using '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST= 172.xx.xx.22)(PORT = 1521)))(CONNECT_DATA=(SERVICE_NAME=XXX)))';
select owner,db_link,username from dba_db_links;