Shulou(Shulou.com)06/01 Report--

IMP-00010: not a valid export file on oracle import, header verification failed

Problem description:

IMP-00010: not a valid export file on oracle import, header verification failed

Import the dmp file exported by oracle 11g into oracle10g

Problem: import table operation, prompt:

IMP-00010: not a valid export file, header verification failed

IMP-00000: import was not terminated successfully

Solution:

Query the oracle version number in the dmp backup file, the major version number must be the same, otherwise it will not succeed.

Consider using editing software such as notepad++/UE/editplush to open the dmp file and modify it

To make it clear that the backup mode of dmp is exported by the exp/expdp/ tool, import the imp/impdp/ tool in a relative way

The most important thing is to find out who is the table user before the dmp file to be imported. The user should be created in advance in the machine to be imported, otherwise it may lead to unsuccessful creation of views, triggers, etc.

The method of querying the oracle version number is posted below:

Method 1: 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 2: 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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.