用dblink吧,比较方便,如果跨数据库需要考虑写应用程序实现
dblink的创建使用:
1.创建dblink语法：
CREATE [PUBLIC] DATABASE LINK link
CONNECT TO username IDENTIFIED BY password
USING ‘connectstring’
例子:
create database link link_tgwms_histdb connect to usernameidentified by password
using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.215.13)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = histdb)
)
)';
2.查看已创建的dblink
select owner,object_name from dba_objects where object_type='DATABASE LINK';
3.dblink的引用：
[user.]table|view@dblink
如：
SELECT * FROM worker@zrhs_link;
SELECT * FROM camel.worker@zrhs_link ;
