Return
-
Title
Cannot multiple .dmp files be imported in the Data Pump Import Wizard? -
Description
Toad users cannot configure the Data Pump Import Wizard to accept multiple .dmp files.
-
Resolution
WORKAROUND:
No workaround exists in Toad. You will need to run the Data Pump Import from the command line if you would like to load multiple .dmp files.
Example
impdp scott/tiger SCHEMAS='scott' CONTENT=METADATA_ONLY JOB_NAME='testJob' DIRECTORY=ANY_DIR PARALLEL=2 DUMPFILE=ANY_DIR:first.dmp DUMPFILE=ANY_DIR:second.dmp LOGFILE=testJob.log
STATUS:
This feature has been submitted as an enhancement request. -
Defect ID
ER# 298