Import Multiple dump files using Data Pump

To import multiple dump files using Data Pump, use substitution variable (%u).

For example:

impdp / DIRECTORY=pump_dir LOGFILE=parallel_import.log DUMPFILE=par_exp%u.dmp PARALLEL=2 TABLE_EXISTS_ACTION=REPLACE

TABLE_EXISTS_ACTION={SKIP APPEND TRUNCATE REPLACE}
The possible values have the following effects:

• SKIP leaves the table as is and moves on to the next object. This is not a valid option if the CONTENT parameter is set to DATA_ONLY.
• APPEND loads rows from the source and leaves existing rows unchanged.
• TRUNCATE deletes existing rows and then loads rows from the source.
• REPLACE drops the existing table and then creates and loads it from the source. This is not a valid option if the CONTENT parameter is set to DATA_ONLY.