How to impdp ? Oracle Multiple Dump File with their Corresponding Tables

1.2k Views Asked by At

I am trying to import the data from dump file , so I created the test.par file which contains multiple dump file for each table and in the below table parameter I have mentioned the table name correspondingly.

Test.Par

 DUMPFILE=PIECE_HI.dmp,PIECE_HI_HIST.dmp
    DIRECTORY=ACSDB_DATAPUMP_DIR
    LOGFILE=impdp1.log
    table_exists_action=APPEND
    content=DATA_ONLY
    IGNORE=Y
    TABLES=PIECE_HI,PIECE_HI_HIST

While trying to access the par file from shell script, I am getting the below error

ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39140: dump file "/appl/acs/loader/ACSDB_DATAPUMP_DIR/PIECE_STATUS.dmp" belongs to job "ACSAPPLUSR3"."SYS_EXPORT_TABLE_01"
0

There are 0 best solutions below