ORACLE DBLINK

创建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;