合 12C的dmp文件导入11G报错IMP-00010: not a valid export file, header failed verification
👉 本文共约1262个字，系统预计阅读时间或需5分钟。
目录
前言部分
导读和注意事项
各位技术爱好者，看完本文后，你可以掌握如下的技能，也可以学到一些其它你所不知道的知识，\~O(∩_∩)O\~：
① 12C的dmp文件导入11g数据库
② IMP-00010: not a valid export file, header failed verification错误解决一例
③ 软件PilotEdit Lite的使用
④ 从dmp文件头获取导出的版本、时间、用户
⑤ 查看dmp文件的字符集
本文简介
今天客户给了一个ash的dmp文件，需要分析一下，结果导入数据库的时候发生了IMP-00010: not a valid export file, header failed verification的错误，我用软件PilotEdit Lite打开的时候发现原来导出文件使用的是12C的客户端，而我手头没有12c的客户端，于是将文件头修改为TEXPORT:V11.02.00，然后即可顺利导入了数据库，下面给出详细过程。
错误解决
IMP-00010: not a valid export file, header failed verification
1 2 3 4 5 6 7 8 9 10 11 | D:\Users\xiaomaimiao>imp 'sys/lhr@192.168.59.129/oratest as sysdba' full=y file="E:\ash_20161108.dmp\ash_20161108.dmp" Import: Release 11.2.0.1.0 - Production on Wed Nov 9 11:26:05 2016 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.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 |
使用软件PilotEdit Lite打开（此软件可以打开上G的文件）：
修改为如下的形式：
重新导入数据库：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | D:\Users\xiaomaimiao>imp 'sys/lhr@192.168.59.129/oratest as sysdba' full=y file="E:\ash_20161108.dmp\ash_20161108_01.dmp" Import: Release 11.2.0.1.0 - Production on Wed Nov 9 11:28:24 2016 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Export file created by EXPORT:V11.02.00 via conventional path import done in ZHS16GBK character set and AL16UTF16 NCHAR character set export client uses US7ASCII character set (possible charset conversion) . importing SYS's objects into SYS . importing SYS's objects into SYS . . importing table "ASH_20161108" 29394 rows imported Import terminated successfully without warnings. |
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信dbaup66，谢谢！
