Skip to Main Content

Chinese

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

10.2.0.1 如何exp导出schema数据到不同的tablespace下

957155Aug 26 2012 — edited Aug 27 2012
现有一库:用户A 默认表空间为data01,
create user a identified by a default tablespace data01;
grant connect,resource to a;

用户A导出数据:exp a/a@orcl file=E:\orcl.dmp log=E:\orcl.log

另一库: 用户B ,默认表空间为data02,还有一表空间data03,现在想将数据导入到data03中,
create user b IDENTIFIED by b default tablespace data02;
grant dba,connect,resource to b;
alter user b quota 0 on data02;
alter user b quota unlimited on data03;

执行导入:imp b/b@dbtest file=E:\orcl.dmp fromuser=a touser=b tablespaces=data03 log=dbtest.log

导完后结果还是在data02中.

这个怎么解决??

数据库版本:Release 10.2.0.1.0

Edited by: 954152 on 2012-8-26 上午7:23

Edited by: 954152 on 2012-8-26 上午7:25
This post has been answered by LiuMaclean(刘相兵) on Aug 26 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 24 2012
Added on Aug 26 2012
6 comments
1,644 views