两个数据库先建立数据链接. CREATE DATABASE LINK conn_BBBASE CONNECT TO CURRENT_USER USING 'BBBASE';select a.* ,b.* from AABASE.AA a ,conn_BBBASE.BB b where a.name =b.user 视权限分配
在pl/sql下的database lines下建立BBBASE数据库的数据连接(名称为wwww), select * from aa a,bb@wwww b where a.name = b.user
在数据库服务器中要建立BBBASE数据库的监听
写法一样,用数据库名区分. CREATE DATABASE LINK conn_BBBASE CONNECT TO CURRENT_USER USING 'BBBASE';select a.* ,b.* from AABASE.AA a ,BB@conn_BBBASE b where a.name =b.user
CREATE DATABASE LINK conn_BBBASE CONNECT TO CURRENT_USER USING 'BBBASE';select a.* ,b.* from AABASE.AA a ,conn_BBBASE.BB b where a.name =b.user
视权限分配
select * from aa a,bb@wwww b where a.name = b.user
CREATE DATABASE LINK conn_BBBASE CONNECT TO CURRENT_USER USING 'BBBASE';select a.* ,b.* from AABASE.AA a ,BB@conn_BBBASE b where a.name =b.user