Oracle中dblink的创建与删除
查询数据库中有哪些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;
作者:小策一喋
邮箱:xvpindex#qq.com
出处:http://www.cnblogs.com/xvpindex/
本文版权归作者和博客园共有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利。如果觉得本文对您有益,欢迎点赞、欢迎探讨。本博客来源于互联网的资源,若侵犯到您的权利,请联系博主予以删除。