0

The original data pump file is generated by the schema which living in two tablespaces(OLD_SCHEMA_DAT and OLD_SCHEMA_IDX), if import back to the original tablespace, everything is fine, but when I use following command:

impdp OLD_USER/OLD_PASS dumpfile=whole.package.dmp directory=DATA_PUMP_DIR
REMAP_SCHEMA=ORIGINAL_SCHEMA:NEW_SCHEMA

It works but with 200 errors stating that

ORA-39083: Object type CONSTRAINT failed to create with error:
ORA-00959: tablespace 'OLD_SCHEMA_IDX' does not exist

it looks for the original index tablespace instead of the new one, and even I tried:

impdp OLD_USER/OLD_PASS dumpfile=whole.package.dmp directory=DATA_PUMP_DIR
REMAP_TABLESPACE=OLD_SCHEMA_DAT:NEW_SCHEMA_DAT
REMAP_TABLESPACE=OLD_SCHEMA_IDX:NEW_SCHEMA_IDX

Still did not resolve the problem, then what to do? I am on 11g.

4

There is only one REMAP_TABLESPACE parameter in de command.
It would be seperated with ",".
REMAP_TABLESPACE=OLD_SCHEMA_DAT:NEW_SCHEMA_DAT,OLD_SCHEMA_IDX:NEW_SCHEMA_IDX

Oracle doc impdp 11.2 http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_import.htm#SUTIL929

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.