创建一个DBLINK
CREATE PUBLIC DATABASE LINK 名称
CONNECT USERNAME IDENTIFIED BY PASSWORD
USING 另一数据库名select * from cmp_table a,table@名称 where ....
CREATE PUBLIC DATABASE LINK 名称
CONNECT USERNAME IDENTIFIED BY PASSWORD
USING 另一数据库名select * from cmp_table a,table@名称 where ....
参考ORACLE帮助文档:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_56a.htm#SQLRF01205