blocks|key|3068029|text|如果在这两个数据库之间有网络连接，那么使用第一个服务器在第二个数据库服务器上执行import命令。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3068030|在执行imp命令时，您必须小心，确保您使用imp命令瞄准了第二个数据库。|3068031|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

if you have a network connection between these two databases
then use the first server to execute the import command on the second database server.

you have to be careful when executing imp command, be very sure that you targeted the second database with imp command.

blocks|key|3068045|text|IMP-00010:没有有效的导出文件，标头验证失败.这将给您的印象是，您要导入的文件有问题。我也犯了同样的错误，但那只是愚蠢的甲骨文。我的档案没什么问题。imp用户/密码@+server+/service+FILE=mydumpfile.dmp上面的命令给出了来自我的客户端PC的错误，但是如果我使用远程桌面连接从服务器上运行它，它就能很好地工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3068046|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

IMP-00010: not a valid export file, header failed verification. This would give you the impression that something is wrong with the file you are trying to import. I got the same error but it was just STUPID Oracle being stupid. There was nothing wrong with my file.
 imp user/password@server/service FILE=mydumpfile.dmp
The above command gave the error from my client PC but worked perfectly if I ran it from the server using a remote desktop connection.

blocks|key|2317863|text|IMP-00010:没有有效的导出文件，标头验证失败.|type|blockquote|depth|inlineStyleRanges|entityRanges|data|2317864|今天，当我试图将一个12.0.2DMP文件导入11.2.0数据库时，我得到了这个文件。在Ultraedit中打开dumpfile时，第一行中有一个版本号12.0.2或其他内容。|unstyled|2317865|我怀疑这个号码是IMP-00010的原因，将其手动更改为11.0.2，保存了dumpfile，但未成功。|offset|length|style|BOLD|2317866|显然，imp只检查第1行中的版本号，imp实用程序本身seemes保持不变，至少在oracle数据库的这两个版本之间是这样。|2317867|entityMap^0|0|0|L|D|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$]]|$1|E|3|F|5|D|7|Q|8|@$G|R|H|S|I|J]]|9|@]|A|$]]|$1|K|3|L|5|D|7|T|8|@]|9|@]|A|$]]|$1|M|3|-4|5|D|7|U|8|@]|9|@]|A|$]]]|N|$]]

<blockquote>
 IMP-00010: not a valid export file, header failed verification.
</blockquote>

Today I got this one when trying to import a 12.0.2 dmp file into a 11.2.0
database. When opening the dumpfile in Ultraedit there is a version number 12.0.2 or something in the first line. 

I suspected this number to be the cause for IMP-00010 and changed it manually to 11.0.2, saved the dumpfile, and the imp succeeded.

Obviously imp only checks the version number in line 1, the imp utility itself seemes to be unchanged, at least between this two versions of the oracle database.

blocks|key|3068150|text|当我尝试使用imp命令将从Oracle+11.2.0.4导出到Oracle+11.2.0.2.0版本中的DB转储导入到Oracle+11.2.0.2.0版本时，也会出现同样的问题。这也给了我同样的错误。但是，当我试图将转储文件导入到Oracle+12.1.0.2.0中时，效果很好。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3068151|此问题是由于Oracle旧版本无法正确识别较新的版本转储造成的。因此，您必须尝试使用更新的Oracle版本的转储文件。如果您正在导入和导出不同的甲骨文版本，请阅读它们的文档。|offset|length|3068152|https://docs.oracle.com/database/121/SUTIL/GUID-BAA3B679-A758-4D55-9820-432D9EB83C68.htm#SUTIL110|3068153|entityMap|0|LINK|mutability|MUTABLE|url|1^0|0|2C|2|0|0|0|2P|1|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@$D|R|E|S|1|T]]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@$D|V|E|W|1|X]]|A|$]]|$1|H|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|G]]|O|$5|K|L|M|A|$N|G]]]]

The same issue occur for me when I tried to import DB dump which was exported from Oracle 11.2.0.4 into the Oracle 11.2.0.2.0 version with imp command. It gave me the exact same error. But, When I tried to import dump file into Oracle 12.1.0.2.0 it worked fine.

The issue was due to Oracle older version cannot properly identify the newer version dump. Therefore you have to try dump file with newer Oracle version. If you are import and export between different Oracle version read their <a href="https://docs.oracle.com/database/121/SUTIL/GUID-BAA3B679-A758-4D55-9820-432D9EB83C68.htm#SUTIL110" rel="nofollow noreferrer">documentation</a>.

<a href="https://docs.oracle.com/database/121/SUTIL/GUID-BAA3B679-A758-4D55-9820-432D9EB83C68.htm#SUTIL110" rel="nofollow noreferrer">https://docs.oracle.com/database/121/SUTIL/GUID-BAA3B679-A758-4D55-9820-432D9EB83C68.htm#SUTIL110</a>

blocks|key|3068194|text|从V12.01.00版本导出转储，并尝试将其导入V11.02.00版本|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3068195|使用|3068196|用户名/密码version=11.02+dumpfile=filename.dmp+logfile=filename.log|3068197|dumpfile=filename.dmp+logfile=filename.log用户名/密码|3068198|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

You Export the dump from version V12.01.00 and try to import it into version V11.02.00

Use

expdp username/password version=11.02 dumpfile=filename.dmp logfile=filename.log

impdp username/password dumpfile=filename.dmp logfile=filename.log

I have export DMP files which are exported using the exp command from oracle version 11.2.0.4.0. I want to import the file in my oracle version 11.2.0.2.0. But during import I am getting an error as <code>'IMP-00010 not a valid export file, header failed verification'</code>.
The export dump par file has the following information :
<pre><code>USERID=TEST_CONFIG/TEST_CONFIG@Ik567G 
OWNER=TEST_CONFIG 
LOG=test01.log 
FILE=test01.dmp 
INDEXES=Y 
CONSTRAINTS=Y 
GRANTS=Y 
COMPRESS=Y 
FULL=N 
ROWS=Y 
CONSISTENT=Y 
BUFFER=80200 
FEEDBACK=500 
</code></pre>
And the import DMP test_config par file has the following information :
<pre><code>LOG=TEST_CONFIG.log 
FILE=test01.dmp 
FROM USER=TEST_CONFIG 
FULL=n 
ROWS=n 
 INDEXES=n 
 CONSTRAINTS=y 
IGNORE=y
</code></pre>
I am running the import using following command :
<pre><code>imp TEST_CONFIG/TEST_CONFIG PARFILE=test_config.par 
imp TEST_CONFIG/TEST_CONFIG PARFILE=test_config.par
</code></pre>
I tried to export and import many times and it works for me previously. As we have a different servers and databases now and When I compared and open the previous export file, it's showing the version <code>EXPORT:V11.02.00</code> where I am able to import but now for the new export it's showing the version <code>EXPORT:V12.01.00</code>. So it looks compatibility issue.

IMP-00010 not a valid export file, header failed verification in Oracle Import

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我有导出DMP文件，这些文件使用oracle版本11.2.0.4.0中的exp命令导出。我想导入我的oracle版本11.2.0.2.0中的文件。但是在导入过程中，我得到了一个'IMP-00010 not a valid export file, header failed verification'错误。导出转储pa...

问IMP-00010不是有效的导出文件，在Oracle中标头验证失败
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问IMP-00010不是有效的导出文件，在Oracle中标头验证失败EN