将用户A的数据导入用户B
一。备份用户A数据
cmd下
exp A/passwordA@db file=e:\path.dmp owner=A
二。创建用户B并授权
1.先用DBA用户登入sqlplus(一般用system)
2.create user B identified by passwordB;
grant create session,create table to B;
grant unlimited tablespace to B;
grant create any procedure to B;//拥有创建存储过程的权限
三。将A的备份数据导入B
cmd下
imp A/passwordA@db file=e:\path.dmp ignore=y fromuser=A touser=B
完成
自己写的几个例子:可以参考下!
create table TS_USERPURVIEW as (select * from TS_USERPURVIEW@SV) create table TS_USERPURVIEW as (select * from TS_USERPURVIEW @SV) create table TS_MODEL as (select * from TS_MODEL @SV)