如何将oracle转储文件导入到oracle数据库？
我有客户的oracle转储文件，我使用以下命令将此文件导入到oracle db：
imp user1/tartan@app92g fromuser=SYS touser=user1_1 file=PRD_10_06_11.dmp log=app_log1.log
但出现以下错误：
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully
所以我认为它不是由oracle通用imp/exp进程导出的，它应该由泵导出，有人知道我可以使用什么命令吗？
I have customer oracle dump file, I used the following command to import this file to oracle db:
imp user1/tartan@app92g fromuser=SYS touser=user1_1 file=PRD_10_06_11.dmp log=app_log1.log
But it occurs the following error:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully
So I am thinking it is not exported by oracle common imp/exp process, it should be exported by pump, Is anybody have idea what command I can use?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
尝试使用
impdp。最好的办法是询问你的客户他是如何产生这个转储的。
Try using
impdp.The best thing to do is to ask your customer how he produced this dump though.