如何将 oracle 11g 转储文件导入到 10g oracle
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/21876576/
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
how to import oracle 11g dump file to 10g oracle
提问by ezzaam
when i tried to import oracle database 11g into oracle 10g i got this error.
当我尝试将 oracle 数据库 11g 导入到 oracle 10g 时，出现此错误。
IMP:00010 Not a valid export file. header failed identification
IMP:00000 Import terminated unsucessfully
IMP:00010 不是有效的导出文件。标头识别失败
IMP:00000 导入终止失败
any help please
任何帮助请
回答by 124
You can import your Oracle 11gexpdp dump fileinto Oracle 10gif you make sure you use VERSION=10.2parameter during export. like:
如果您确保在导出期间使用参数，则可以将您的Oracle 11gexpdp dump file导入。喜欢：Oracle 10gVERSION=10.2
expdp hr/hr TABLES=hr.employees VERSION=10.2 DIRECTORY=data_pump_dir
DUMPFILE=emp.dmp LOGFILE=emp.log
(Assuming you want to import in Oracle 10.2)
（假设您要导入Oracle 10.2）
and use impdpas usual, like:
并impdp照常使用，例如：
impdp hr/hr TABLES=hr.employees DIRECTORY=data_pump_dir
DUMPFILE=emp.dmp LOGFILE=emp_imp.log
回答by Giova
From oracle KB:
来自甲骨文知识库：
IMP-00010: Not a valid export file, header failed verification
Cause: Either it is not a file generated by the Export utility or that the file is corrupted.
Action: Check if file was transferred in Binary-mode. If the file was indeed generated by the Export utility, **and no compatibility issue is related**, report this as an Import bug.
As Incognito says you: If you want to move data from a higher version database to a lower version database using exp/imp utilities, you must run the exp client version matching the target database against the source database.
正如 Incognito 所说：如果您想使用 exp/imp 实用程序将数据从较高版本的数据库移动到较低版本的数据库，则必须针对源数据库运行与目标数据库匹配的 exp 客户端版本。
The followings are the compatibility matrix for exp/imp utilities between different versions
以下是不同版本之间 exp/imp 实用程序的兼容性矩阵
+-----------+--------------------------------------------------------------+
| EXPORT | IMPORT into: |
| from +--------+--------+--------+--------+--------+-----------------+
| \/ | 8.1.7 | 9.2.0 | 10.1.0 | 10.2.0 | 11.1.0 | 11.2.0 | |
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 5.x 1)2)| EXP5x | EXP5x | EXP5x | EXP5x | EXP5x | EXP5x | |
| 6.x 2)| EXP6x | EXP6x | EXP6x | EXP6x | EXP6x | EXP6x | |
| 7.x 3)| EXP7x | EXP7x | EXP7x | EXP7x | EXP7x | EXP7x | |
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 8.0.3 | EXP803 | EXP803 | EXP803 | EXP803 | EXP803 | EXP803 | |
| 8.0.4 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804 | EXP804 | |
| 8.0.5 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805 | EXP805 | |
| 8.0.6 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806 | EXP806 | |
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 8.1.5 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815 | EXP815 | |
| 8.1.6 | EXP816 | EXP816 | EXP816 | EXP816 | EXP816 | EXP816 | |
| 8.1.7 | EXP817 | EXP817 | EXP817 | EXP817 | EXP817 | EXP817 | |
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 9.0.1 | EXP817 | EXP901 | EXP901 | EXP901 | EXP901 | EXP901 | |
| 9.2.0 | EXP817 | EXP920 | EXP920 | EXP920 | EXP920 | EXP920 | |
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 10.1.0 4)| EXP817 | EXP920 | 4) | |
| 10.2.0 4)| N/S | EXP920 | 4) | |
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 11.1.0 4)| N/S | EXP920*| 4) | 5) | |
| 11.2.0 4)| N/S | EXP920*| 4) | 5) | |
+-----------+--------+--------+--------+--------+--------+--------+--------+
+-----------+--------------------------------------------------------------+
| EXPORT | IMPORT into: |
| from +--------+--------+--------+--------+--------+--------+--------+
| \/ | 5.x | 6.x | 7.x | 7.3.x | 8.0.x | 8.1.x | 9.0.1 |
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 5.x 1) 2)| EXP5x | EXP5x | EXP5x | EXP5x | EXP5x | EXP5x | EXP5x |
| 6.x 2)| N/S | EXP6x | EXP6x | EXP6x | EXP6x | EXP6x | EXP6x |
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 7.0.x 3)| N/S | EXP6x | EXP7x | EXP70x | EXP70x | EXP70x | EXP70x |
| 7.1.x 3)| N/S | EXP6x | EXP7x | EXP71x | EXP71x | EXP71x | EXP71x |
| 7.2.x 3)| N/S | EXP6x | EXP7x | EXP72x | EXP72x | EXP72x | EXP72x |
| 7.3.x 3)| N/S | EXP6x | EXP7x | EXP73x | EXP72x | EXP73x | EXP73x |
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 8.0.x 4)| Not Supported | EXP7x | EXP73x | EXP80x | EXP80x | EXP80x |
| 8.1.x 4)| Not Supported | EXP7x | EXP73x | EXP80x | EXP81x | EXP81x |
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 9.0.1.x | Not Supported | 5) | EXP81x | EXP901 |
| 9.2.0.x | Not Supported | 5) | N/S | EXP901 |
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 10.1.0.x | Not Supported | EXP901 |
| 10.2.0.x | Not Supported | N/S |
+-----------+--------+--------+--------+--------+--------+--------+--------+
| 11.1.0.x | Not Supported |
| 11.2.0.x | Not Supported |
+-----------+--------+--------+--------+--------+--------+--------+--------+
Regards Giova
问候乔娃
回答by orlando medina
One way to do this (not coolest one, but handy) is that open the DMP from 11G with vi or any kind of good text/console editor and in the first lines of the file.
执行此操作的一种方法（不是最酷的方法，但很方便）是使用 vi 或任何类型的文本/控制台编辑器在文件的第一行中从 11G 打开 DMP。
It shows the version number 11 (in this case), so you can just edit the text and change it then save it. After this you can try to load the DMP and will work.
它显示版本号 11（在这种情况下），因此您可以编辑文本并更改它然后保存它。在此之后，您可以尝试加载 DMP 并将工作。
This is the Punk way!
这就是朋克风格！
Hope it helps and pardon my broken english
希望它有所帮助并原谅我破碎的英语
回答by Nguyen Truong Dai
IMP-00010: not a valid export file, header failed verification IMP-00000: Import terminated unsuccessfully
IMP-00010：不是有效的导出文件，标头验证失败 IMP-00000：导入终止失败
because dump from linux but you import from window. action: imp from linux
因为从 linux 转储但您从窗口导入。动作：来自Linux的imp
