第一种方法:要求数据库服务器 A 上tnsnames.ora 中有数据库 B 的映射
-- --create database link 数据库链接名 connect to 用户名 identified by 密码 using '本地配置的数据的实例名';
第二种:
createdatabase link vipdb_link connect to cachedb_vvip identified by cachedb_vvipusing '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.1)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = vipdb)
)
)';