Export and import right application or execute import imp-00010 error solve

① 、 Export and import right application

Source database: the database where the data is exported from

Target database: the database where the data is imported into

Clients database:

1 、 the databse where the data is exported dump files from source database  

2 、 the database where the data is imported dump files into target database

sound approach

EXPORT:

Clients database version <= source database version

IMPORT:

Clients database version <= target database version

② 、 execute import imp-00010 error solve

1 、 error environment

Export dump files

Source database: 11.2.0.1

Clients database: 11.2.0.1

Import dump files

Target database:10.2.0.1

Clients database:10.2.0.1

2 、 execute import error

IMP-00010:Not   a  valid export file,header failed verification
IMP-00000:Import terminated unsuccessfully

3 、 Solution

first solution way ： export dump files from clients database (equal to target database 10.2.0.1) – 【 Recommended Method 】

second solution way : modify export dump files header

1、 using UE open export dump files

TEXPORT:V11.02

2、 modify export dump files header

TEXPORT:V10.02

         3 、 import is ok

附表：            

（ Exp 和 imp 正确应用 ）或（ imp 报错 imp-00010 解决方法）

一、（ Exp 和 imp 正确应用 ）

正确方法

Export

客户端的数据库版本《 = 源数据库的版本

Import

客户端的数据库版本《 = 目标数据库的版本

二、（ imp 报错 imp-00010 解决方法）

1 、问题环境重现

高版本 exp ，然后低版本 imp 错误类型

2 、报错信息

IMP-00010:Not   a  valid export file,header failed verification
IMP-00000:Import terminated unsuccessfully

3 、解决方法

第一方法：更改 exp 客户段数据库的版本

第二方法：直接使用 UE 修改 export dump file 头验证 ( 把 TEXPORT:V11.02 修改成 TEXPORT:V10.02 )

http://docs.oracle.com/cd/E11882_01/server.112/e22490/original_export.htm#SUTIL2103

Examples of Using Different Releases of Export and Import

Table 21-5 shows some examples of which Export and Import releases to use when moving data between different releases of the Oracle database.

Table 21-5 Using Different Releases of Export and Import

Table 21-5 covers moving data only between the original Export and Import utilities. For Oracle Database 10 g release 1 (10.1) or higher, Oracle recommends the Data Pump Export and Import utilities in most cases because these utilities provide greatly enhanced performance compared to the original Export and Import utilities.