Thursday, May 17, 2012

impdp ORA-39083 ORA-00959


At import time you can get these errors:

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

In this case use REMAP_TABLESPACE=IDX:[destination tablespace]
If you have multiple tablespaces, for each use
REMAP_TABLESPACE=[source tablespace]:[destination tablespace]

Example:

impdp user/passsword@sid directory=dir remap_schema=schema_source_schema:dest_schema remap_tablespace=tab1:tab remap_tablespace=tab2:tab dumpfile=file.dmp logfile=file.log

No comments:

Post a Comment