前提是,在user1中有user2中表的select权限 sql>set head off sql>spool c:\test.sql sql>select 'insert into user1.'||table_name||' select * from user2.'||table_name||';' from user_tables; sql>spool off sql>quit
条件: a.T1, b.T2有相同的数据结构.方法: 1. grant select,insert,update on a.T1 to b; 2. insert into b.T2 select col1, col2,.... from a.T1.
sql>set head off
sql>spool c:\test.sql
sql>select 'insert into user1.'||table_name||' select * from user2.'||table_name||';' from user_tables;
sql>spool off
sql>quit
1. grant select,insert,update on a.T1 to b;
2. insert into b.T2 select col1, col2,.... from a.T1.