PL/SQL：database links

最新推荐文章于 2022-08-08 14:38:51 发布

sshmobai

最新推荐文章于 2022-08-08 14:38:51 发布

阅读量1.4k

点赞数

分类专栏： oracle

本文链接：https://blog.csdn.net/m0_38084243/article/details/81530521

版权

oracle 专栏收录该内容

17 篇文章 0 订阅

订阅专栏

1 在被连接的数据库上，查看监听配置文件

2 tnsnames.ora

3 复制所需要连接用户的DESCRIPTOIN

  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

4 在连接的数据库上，新增database links

5 选择需要的信息，数据库的内容为上述的DESCRIPTOIN，也可以间写为：localhost:1521/orcl

6 创建database links对应的sql语句

-- Create database link 
create database link dblink_scott
  connect to scott identified by tiger
  using '(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl)))';