Oracle创建数据库链接

最新推荐文章于 2024-08-14 09:55:00 发布

weixin_34102807

最新推荐文章于 2024-08-14 09:55:00 发布

阅读量112

点赞数

文章标签：网络数据库

原文链接：http://www.cnblogs.com/hjianguo/p/6203394.html

版权

**********创建数据库链接******************
create public database link link_gzzl
connect to system identified by "123456"
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.20)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = GZZL)
)
)';
***********从A库取B库的数据
select * from pat_master_index@likn_gzzl;

转载于:https://www.cnblogs.com/hjianguo/p/6203394.html