Skip to Main Content

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-31640: unable to open dump file

User_11X2OMar 19 2023

I am using oracle 12c

when I try to import data into the database using data pump I am getting the following error

ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/u01/app/oracle/neelaka/pdb519032023.dmp" for read
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7

Syntaxed that I used to import

impdp dpuser/Pa12340rd@pdb4 full=Y directory=neelaka dumpfile=pdb519032023.dmp logfile=pdb519032024.log

Note: I gave the following permission to the directory which I created

$chmod 777 /u01/app/oracle/neelaka

SQL>grant read,write on directory neelaka to dpuser;

Please let me know why this error is coming even though I assigned permission for the directory. Dump also in good condition

Comments
Post Details
Added on Mar 19 2023
4 comments
3,141 views