Oracle中dblink的创建与删除

佐佑时代

于 2017-07-18 13:47:00 发布

阅读量897

点赞数 1

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/zhaoxiace/article/details/84533467

本文介绍了如何使用SQL语句查询、创建及删除Oracle数据库中的DBLink连接，并提供了测试连接是否可用的方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

查询数据库中有哪些dblink连接

select * from dba_objects where object_type='DATABASE LINK';

删除公有的EMIS_PRODUCTOIN连接

drop public database link EMIS_PRODUCTION;

创建公有的EMIS_PRODUCTION连接

create public database link EMIS_PRODUCTION connect to EMIS_FRAME identified by EMIS_FRAME using '(DESCRIPTION =
(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521)))
(CONNECT_DATA = (SERVICE_NAME = testdb))
)';

删除EMIS_PRODUCTION连接

drop database link EMIS_PRODUCTION;

创建EMIS_PRODUCTION连接

create database link EMIS_PRODUCTION connect to EMIS_FRAME identified by EMIS_FRAME using '(DESCRIPTION =
(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521)))
(CONNECT_DATA = (SERVICE_NAME = testdb))
)';

测试是否可用

select * from EMIS_FRAME.sys_menu@EMIS_PRODUCTION;