Geek Answers Handbook

Exception: ORA-31640: Unable to open dump file "..." for reading

When I try to import a .DMP file through SQL developer, I get this error

Exception: ORA-31640: unable to open dump file "/home/oracle/Desktop/dump/vahe.DMP" for read

The dump directory and the vahe.dmp file have read and write permissions. enter image description here

I use VM Development for application development. How can I fix this problem? Thanks.

+5
source share
2 answers

Well, I found a problem. Actually, I had a type error. I have a typo "vahe.DMP" instead of "vahe.dmp" (lowercase). I think the error message is not very good, because it should clearly say that the file does not exist, and does not say "cannot open dump file for reading" (IMHO)

Thanks to everyone who tried to help me.

+3
source

I had the same error while importing a DMP file that was received from a colleague. error "ora-31640 could not open the dump file for reading" Having created a new user with the same name and password that was used to create the DMP file and used this user to connect and import, he solved this error.

I imported data using the "Import Data Wizard" in oracle 11g R2 server.

0
source

More articles:


All Articles