首先在服务器A创建dblink:db_serverB,然后: select a.*,b.* from table1 a,where scheme.table2@db_serverB b where a.id=b.id;
不好意思,写错了 应该是:首先在服务器A创建dblink:db_serverB,然后: select a.*,b.* from table1 a,scheme.table2@db_serverB b where a.id=b.id;
首先在服务器A创建连接 create database link linke1 connect by user1 Identified by password1 using service1; 然后: select a.*,b.* from table1 a,scheme.table2@linke1 b where a.id=b.id;
select a.*,b.* from table1 a,where scheme.table2@db_serverB b where a.id=b.id;
应该是:首先在服务器A创建dblink:db_serverB,然后:
select a.*,b.* from table1 a,scheme.table2@db_serverB b where a.id=b.id;
create database link linke1
connect by user1 Identified by password1
using service1;
然后:
select a.*,b.* from table1 a,scheme.table2@linke1 b where a.id=b.id;