Do I have to use REMAP_SCHEMA to import (IMPDP) data pump dump file?
Is there a way to import a data pump dump file without using import parameters REMAP_SCHEMA and REMAP_TABLESPACE if the names of new schema and its tablespace are not identical to those of source schema? In another word, do I have to list the names of source schema and tablespaces in order to import?
Here is the example.
The dump file was exported from schema SOURCEDB in tablespace PRODUCTION_DATA.
$expdp sourcedb/sourcedb directory=dpexp dumpfile=sourcedb.dmp
Try to import to schema TEST created in tablespace TESTDP_DATA. But tablespace PRODUCTION_DATA also exists.
IMPDP did not work if remap_schema is not used.
Here is the example.
The dump file was exported from schema SOURCEDB in tablespace PRODUCTION_DATA.
$expdp sourcedb/sourcedb directory=dpexp dumpfile=sourcedb.dmp
Try to import to schema TEST created in tablespace TESTDP_DATA. But tablespace PRODUCTION_DATA also exists.
IMPDP did not work if remap_schema is not used.
0