要跨库访问数据时,可通过创建dblink来实现。
create database link Testlink connect to Username identified by Password
using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.16.2)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = Test)))'
Testlink: dblink连接名
Username: 要访问的数据库的用户
Password: 要访问的数据库用户密码
HOST: 要访问的数据库ip
SERVICE_NAME: 要访问的数据库服务名
访问:
select * from jkrb@Testlink;
删除dblink:
drop database link Testlink;