oracle 异常：ORA-31640：无法打开转储文件“...”进行读取
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/29455351/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Exception: ORA-31640: unable to open dump file "..." for read
提问by user1321466
When I am trying to import .DMP file via SQL developer I am getting this error
当我尝试通过 SQL 开发人员导入 .DMP 文件时，出现此错误
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. 
dump目录和vahe.dmp文件有读写权限。
I use Database App Development VM. how can I fix this issue ? Thanks.
我使用数据库应用程序开发 VM。我该如何解决这个问题？谢谢。
回答by user1321466
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)
嗯，我发现了问题。其实我有类型错误。我有错字“vahe.DMP”而不是“vahe.dmp”（小写）。我认为错误消息不是一个好消息，因为它应该清楚地说明该文件不存在而不是说“无法打开转储文件''进行读取”（恕我直言）
Thanks everybody who tried to help me.
感谢所有试图帮助我的人。
回答by Raman B
I was having the same error while importing DMP file shared from colleague. error “ora-31640 unable to open dump file for read” By creating new user with same name and password which was used while creating DMP file, and used this user for connect and importing, it resolved this error.
我在导入同事共享的 DMP 文件时遇到了同样的错误。错误“ora-31640 无法打开转储文件进行读取” 通过创建与创建 DMP 文件时使用的名称和密码相同的新用户，并使用该用户进行连接和导入，解决了此错误。
I was importing the data using "Data Pump Import Wizard" in oracle 11g R2 server.
我在 oracle 11g R2 服务器中使用“数据泵导入向导”导入数据。
