oracle imp时表空间,imp时指定表空间

今天终于把imp时指定表空间的问题搞定了！

为了只是看看效果，所以我只导了两张表做实验

摘要：

exp mctest3/mctest file=/home/oracle/order0016.dmp

tables=order0015_purchase_plan_detail,order0014_purchase_plan

select * from user_tables where

table_name='ORDER0015_PURCHASE_PLAN_DETAIL' or

table_name='ORDER0014_PURCHASE_PLAN'

revoke unlimited tablespace from simply

alter user simply quota unlimited on simply

alter user simply quota 0 on system

imp fromuser=mctest3 touser=simply file=/home/oracle/order0016.dmp

TABLESPACES=SIMPLY

步骤一，导出单张表

37服务器上mctest3模式里的

'ORDER0015_PURCHASE_PLAN_DETAIL'

'ORDER0014_PURCHASE_PLAN'

[oracle@meta ~]$ exp mctest3/mctest

file=/home/oracle/order0016.dmp

tables=order0015_purchase_plan_detail,order0014_purc