Oracle 跨库查询 通过DBLINK

1、 首先找到database links

在数据库A中建立DBLINK如下：新建----填写DBLink名称，填写访问数据库B的连接信息----点击应用

 

 

 数据库描述部分:

(DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 数据库B IP地址)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SID = 数据库B实例名)

      (SERVER = DEDICATED)

    )

  )

 

create database link DBLINK_TEST(LINK名称)
connect to  用户名 identified by "密码"
using '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.XXX.XXX)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)';

 

2 查询测试

select * from  数据库B里面的表名称@DBLINK名称