不同表空间数据迁移:
create tablespace spacetest datafile 'E:\oracle\product\10.2.0\oradata\orcl\spacetest.dbf' size 10m autoextend on;
create user test01 identified by test01 default tablespace spacetest;
grant dba to test01;
设定用户
revoke unlimited tablespace from test01
alter user test01 quota unlimited on spacetest
alter user test01 quota 0 on system
imp test01/test01 fromuser=rc touser=test01 file=D:\rc.dmp tablespaces=spacetest;