Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Exception: ORA-31640: unable to open dump file "..." for read

When I am trying to import .DMP file via SQL developer I am getting this error

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

dump directory and vahe.dmp file have read and write permission. enter image description here

I use Database App Development VM. how can I fix this issue ? Thanks.

like image 336
user1321466 Avatar asked Apr 05 '15 08:04

user1321466


1 Answers

Well I found the problem. Actually I had type error. I have typo "vahe.DMP" instead of "vahe.dmp"(in lower case ). I think error message is not good one, because it should clearly say that file does not exist instead of saying "unable to open dump file '' for read" (IMHO)

Thanks everybody who tried to help me.

like image 78
user1321466 Avatar answered Nov 12 '22 07:11

user1321466