不用这么麻烦。^_^。首先建立一个B库到A库的dblink: create database link dblink_name connect to database_A identified by user1.password using 'user1.id'; 然后再以user2登陆B库,执行: create table tab_2 as select * from user1.tab_1@dblink_name; 如果tab_2已经有了就: insert into tab_2 select col_list from user1.tab_1@dblink; commit;
create database link dblink_name connect to database_A identified by user1.password
using 'user1.id';
然后再以user2登陆B库,执行:
create table tab_2 as select * from user1.tab_1@dblink_name;
如果tab_2已经有了就:
insert into tab_2 select col_list from user1.tab_1@dblink;
commit;
我想知道,oracle的实体化视图复制及多主复制可以实现哪些功能?
这样也可以,不知道你的意思是不是这个?
COPY FROM <db> TO <db> <opt> <table> {(<cols>)} USING <sel>
可以吗?