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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
2,539 views