Excuse me the oracle great god: when doing import, the original under a user has two table space, how to deal with import? Thank you
When I export is derived according to the user

CodePudding user response:

Exp is exported or expdp?
Expdp words use:
REMAP_TABLESPACE=TBS1: TBS1NEW TBS2: TBS2NEW

CodePudding user response:

If it is imp/exp, and involves the partition table or tables contain LOB field, you need to first create a table, to import the data again