查询创建DBLink

查询

select * from user_sys_privs t where t.privilege like upper('%link%');
select * from all_db_links;

创建

create database link #{linkname} connect to #{tousername} identified by #{password}
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =#{ip})(PORT =#{port} ))
)
(CONNECT_DATA =
(SERVICE_NAME =#{sid})
)
)';