Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-39000: bad dump file specification Error While Import Compressed Dump file

Brijesh PatelOct 14 2014 — edited Dec 4 2014

Hye Dear Friends,

we have RAC DB , and we are exporting the data by datapump using compression option.We have RAC Oracle OEnterprice DB 11.2.0.3 with sun Solaris.

SO Export successfully completed.

our export command

expdp UN/PW directory=abcd compression=all dumpfile=abcd.dmp log=abcdlog.log schemas=abcd

Out windows Server is also having same DB Oracle Enterprise 11.2.0.3

But when we wants to use this dump file in our Test DB Server, with impdp server - we are facing following errors.

impdp UN/PW directory=abcd dumpfile=abcd.dmp log=abcdlog.log remap_schema=abcd:abcd1

ORA-39001 : Invalid argument value

ORA-39000 : bad dump files specification

ORA-31619 : Invalid dump file......

Thank You,

Brijesh Patel

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 1 2015

Added on Oct 14 2014

#database-key-features, #export-import-sql-loader-external-tables

1 comment

2,637 views