Legacy EXP/IMP file used in Datapump Import Receives error - ORA-39000: Bad Dump File Specification (Doc ID 462261.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Using a legacy export dump file, and importing into a 10g or greater instance using datapump import.


Is it possible to import a DUMP file which taken on an older Oracle version by using IMPDP?

EXAMPLE:

Exporting a table 'PR' using the traditional export.

C:\Documents and Settings\pvelusam>exp system/manager file=exp.dmp tables=prath.pr log=exp.log
Export: Release 10.2.0.1.0 - Production on Fri Oct 5 11:31:22 2007
Copyright (c) 1982, 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
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
About to export specified tables via Conventional Path ...
Current user changed to PRATH
. . exporting table PR 4 rows exported
Export terminated successfully without warnings.

-------------------------------------------------------------------
Tried to Import using IMPDP but it failed.

C:\Documents and Settings\pvelusam>IMPDP SYSTEM/MANAGER DIRECTORY=DATA_PUMP_DIR
DUMPFILE=EXP.DMP TABLES=PRATH.PR REMAP_SCHEMA=PRATH:PRATH
Import: Release 10.2.0.1.0 - Production on Friday, 05 October, 2007 12:03:27
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prodution
With the Partitioning, OLAP and Data Mining options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "D:\oracle\product\10.2.0\admin\orcl\dpdump
EXP.DMP" for read
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

-----------------------------------------------------------------------
Then Imported using traditional import which succeeded.

C:\Documents and Settings\pvelusam>imp system/manager file=exp.dmp tables=PR FROMUSER=PRATH
TOUSER=PRATH
Import: Release 10.2.0.1.0 - Production on Fri Oct 5 11:53:06 2007
Copyright (c) 1982, 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
Export file created by EXPORT:V10.02.01 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. importing PRATH's objects into PRATH
. . importing table "PR" 4 rows imported
Import terminated successfully without warnings

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms