如有两台DB(A和B),A要查B的数据库资料
一、先在A的TNSNAMES.ORA 里添加 B的侦听信息,比如:
BBK10 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.106.111)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = S10)
)
)
二、创建dblink name: abc
1、在A数据库服务器上登录进去,用System账号在sqlplus登录进去
2、执行
SQL> CREATE PUBLIC DATABASE LINK "abc" CONNECT TO "B服务器的DB帐号"
IDENTIFIED BY "密码"
USING 'BBK10';
三、使用方法为:select *from 表名@abc;