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/，如需轉載，請註明出處，否則將追究法律責任。