oracle Database – Enterprise Edition
Information in this document applies to any platform.

Evidence
[oracle@lovetech exp_dir]$ impdp system/xxxxxx directory=datapump dumpfile=scottss.dmp logfile=imp_schema.log remap_schema=’SCOTT:SCOTT’

Import: Release 11.2.0.1.0 – Production on Thu Sep 9 00:23:14 2021

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file “/u01/exp_dir/scottss.dmp” for read
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

Findings
Determine if the DIRECTORY_PATH exist
Determine if the dumpfile specified exist

[oracle@lovetech exp_dir]$ cd /u01/exp_dir/
[oracle@lovetech exp_dir]$ ll
total 240
-rw-r–r–. 1 oracle oinstall 551 Sep 9 00:23 imp_schema.log
-rw-r—–. 1 oracle oinstall 241664 Sep 9 00:19 scotts.dmp

Cause
Wrong dumpfile name was specified

Solution
Specify correct dumpfile name and kick off the export again

[oracle@lovetech01 exp_dir]$ impdp system/xxxxx directory=datapump dumpfile=scotts.dmp logfile=imp_schema.log remap_schema=’SCOTT:SCOTT‘

Import: Release 11.2.0.1.0 – Production on Thu Sep 9 00:24:27 2021

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table “SYSTEM”.”SYS_IMPORT_FULL_01″ successfully loaded/unloaded
Starting “SYSTEM”.”SYS_IMPORT_FULL_01″: system/ directory=datapump dumpfile=scotts.dmp logfile=imp_schema.log remap_schema=SCOTT:SCOTT
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported “SCOTT”.”DEPT” 5.937 KB 4 rows
. . imported “SCOTT”.”EMP” 8.570 KB 14 rows
. . imported “SCOTT”.”SALGRADE” 5.867 KB 5 rows
. . imported “SCOTT”.”BONUS” 0 KB 0 rows
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job “SYSTEM”.”SYS_IMPORT_FULL_01″ successfully completed at 00:24:33

The DataPump job runs successfully after specifying correct dumpfile name.

Note: The use of any materials on this website is at your own risk. It is provided for educational purposes only. It has been tested internally, but we do not guarantee that it will work for you. We recommend you test in your test environment before using.