Oracle Import IMP-00010: Not a valid export file, header validation failed

Oracle Import IMP-00010: Not a valid export file, header validation failed

Problem Description:

Oracle Import IMP-00010: Not a valid export file, header validation failed

Importing a DMP file exported by Oracle 11g to oracle10g

Problem: Import table operation, prompt:

IMP-00010: Not a valid export file, header validation failed

IMP-00000: Failed to terminate import successfully

Solution:

1. Query the Oracle version number in the DMP backup file, the major version number must be the same, or it will not succeed.

2. Consider using an editing software such as Notepad++/ue/editplush to open the DMP file and modify

3. To find out how DMP is backed up by exp/expdp/tool export, use the relative way to import the imp/impdp/tool import

4. The most important one is to figure out who the user is before the list of DMP files to be imported, the user should be created in advance in the machine to be imported, or it may cause the creation of views, triggers, etc. to be unsuccessful

   
   

Here's how to post a query for the Oracle version number:

Method One: V$version

Sql> select * from V$version;

Www.2cto.com

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0-64bit Production

PL/SQL Release 11.1.0.7.0-production

CORE 11.1.0.7.0 Production

TNS for Linux:version 11.1.0.7.0-production

Nlsrtl Version 11.1.0.7.0-production

Method Two: Product_component_version

Sql> select * from Product_component_version;

Www.2cto.com

PRODUCT VERSION STATUS

---------------------------------------------------------------------------------------------

Nlsrtl 11.1.0.7.0 Production

Oracle Database 11g Enterprise Edition 11.1.0.7.0 64bit Production

PL/SQL 11.1.0.7.0 Production

TNS for linux:11.1.0.7.0 Production

This article is from the "Isuncle Technology blog" blog, make sure to keep this source http://baoer7758.blog.51cto.com/8187563/1621508

Oracle Import IMP-00010: Not a valid export file, header validation failed