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

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

Export from->Import to	Use Export Release	Use Import Release
8.1.6 -> 8.1.6	8.1.6	8.1.6
8.1.5 -> 8.0.6	8.0.6	8.0.6
8.1.7 -> 8.1.6	8.1.6	8.1.6
9.0.1 -> 8.1.6	8.1.6	8.1.6
9.0.1 -> 9.0.2	9.0.1	9.0.2
9.0.2 -> 10.1.0	9.0.2	10.1.0
10.1.0 -> 9.0.2	9.0.2	9.0.2

 

Table 21-5 covers moving data only between the original Export and Import utilities. For Oracle Database 10g 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.

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26442936/viewspace-752204/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26442936/viewspace-752204/