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