Oracle exp转储文件导入问题IMP-00009:导出文件异常结束
通过 imp 导入 oracle 数据库时,它终止并显示以下错误
IMP-00009: abnormal end of export file
Import terminated successfully with warnings.
The exp was run on the same machine (the data was not ftp betweenservers)
有没有办法从此文件恢复表?
While importing an oracle database via imp, it terminates with below error
IMP-00009: abnormal end of export file
Import terminated successfully with warnings.
The exp was run on the same machine (the data was not ftp between servers)
Is there a way to recover tables from this file?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
检查您的转储文件大小。我遇到了同样的错误,因为我的 .dmp 文件大小为 0KB
Check your Dump file size. I was getting the same error because my .dmp file was of 0KB
这可能是由于操作系统和 Oracle 版本的组合不允许导入大于 2GB 的转储造成的
This is possibly be caused by the combination OS and Oracle versions not allowing importing dumps bigger than 2gb
http://www.serkey.com/tag/oracle-imp-00009/
在这里你会发现很多人在讨论同样的事情。
http://www.serkey.com/tag/oracle-imp-00009/
here you will find lots of people discussing same thing.