1.conn b/b@mis
create table aaa as select * from a.aaa;
2.copy from a/a to b/b create table aaa using select * from aaa;
create table aaa as select * from a.aaa;
2.copy from a/a to b/b create table aaa using select * from aaa;
1.进入用户A模式 grant select on aaa to b
进入用户B模式 create table aaa as(select * from a.aaa)
或;
2.exp a/password tables=(aaa) file=c:\data1.dmp
imp b/password tables=(aaa) IGNORE=Y fromuser=a touser=b file=c:\data1.dmp
第二种方法中若A有DBA 权限则B 为了倒入也必须有DBA权限,即 A的权限应是B的子集
create table aaa as select * from a.aaa;
或者,
copy from .. to ..
copy from .. to ..exp
imp
帮你往前踢一脚,看有没有更好的方法。
to user2/pw2@db2
insert table tbname
using select * from a;
to user2/pw2@db2
insert table tbname
using select * from a;
to user2/pw2@db2
insert table tbname
using select * from a;