ORA-39000, ORA-39143 dump file may be an original export dump file


Problem Description
E:\>impdp directory=test dumpfile=testexp_07_03_09.dmp userid=arju/a

Import: Release 10.2.0.1.0 – Production on Thursday, 07 May, 2009 10:07:00

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production
With the Partitioning, OLAP and Data Mining options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39143: dump file “E:\oracle\Test\testexp_07_03_09.dmp” may be an original export dump file

Cause of the problem
The above problem happened whenever you try to use the Import Data Pump client (impdp) to import a dumpfile that was created with the original Export client (exp).

Though not related but similar error occured.
Like whenever you try to import from an empty file,
E:\>impdp directory=test dumpfile=testexp_07_03_09.dmp userid=arju/a

Import: Release 10.2.0.1.0 – Production on Thursday, 07 May, 2009 10:16:52
Continue reading

Advertisements