创建一个dblink

最新推荐文章于 2018-12-24 11:01:26 发布

weixin_30294295

最新推荐文章于 2018-12-24 11:01:26 发布

阅读量54

点赞数

文章标签：网络数据库

原文链接：http://www.cnblogs.com/rattersnake/archive/2012/05/18/2507903.html

版权

CREATE database link KHTY127_LINK
CONNECT TO KHTY2012 IDENTIFIED BY KHTY2012
USING '(DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.8.127)(PORT = 1521))
    )
    (CONNECT_DATA =
        (SERVICE_NAME = orcl)
    )
)';

SELECT a.id FROM que_answer@KHTY127_LINK a; ok

转载于:https://www.cnblogs.com/rattersnake/archive/2012/05/18/2507903.html