创建DBLINK
create database link JK117
connect to JK
identified by JK
using ‘(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.101.0.117)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)‘;
查看所有的数据库链接,登录管理员查看
select owner,object_name from dba_objects where object_type=‘DATABASE LINK‘;
删除数据库连接
drop database link JK117;
原文:https://www.cnblogs.com/zhouhy6/p/10400614.html