ITPub博客

首页 > Linux操作系统 > Linux操作系统 > imp-00010

imp-00010

原创 Linux操作系统 作者:frog-qs 时间:2011-05-16 15:26:47 0 删除 编辑
开发在导入数据的时候出错。在11g中exp,然后在10g中imp,出现下面错误。
IMP-00010: not a valid export file, header failed verification
 
下面将网上找的一个解决方法和具体说明转过来
Main Reason :
1.File Corrupted During Transfer.
Note : FTP should be done in BINARY MODE

2.When export dump file is higher version and import in lower version.
Note : Use Suppose you want to import 10.2.0.1.0 export dump file in 8.1.7
then you must use 8.1.7 export tools for export data from 10.2.0.1.0.
and run CATEXP.SQL script.
Located : $ORACLE_HOME/rdbms/admin
Install Oracle 9i client and client Oracle 9i client to Oracle 10g server and export your database.



Export From <-----> Import to <-----> Use Import/Export Utility
Version : 10.1.0.2.0 <-----> 9.2 <-----> 9.2
Version : 10.1.0.2.0 <-----> 9.0.1 <-----> 9.0.1
Version : 10.1.0.2.0 <-----> 8.1.7 <-----> 8.1.7
Version : 10.1.0.2.0 <-----> 8.0.6 <-----> 8.0.6


Export From <-----> Import to <-----> Use Import/Export Utility
Version : 9.2.0.1.0 <-----> 9.0.1 <-----> 9.0.1
Version : 9.2.0.1.0 <-----> 8.1.7 <-----> 8.1.7
Version : 9.2.0.1.0 <-----> 8.0.6 <-----> 8.0.6
Version : 9.2.0.1.0 <-----> 7.3.4 <-----> 7.3.4 plus run catexp7.sql



Export From <-----> Import to <-----> Use Import/Export Utility
Version : 9.0.1.1.2 <-----> 8.1.7 <-----> 8.1.7
Version : 9.0.1.1.2 <-----> 8.0.6 <-----> 8.0.6
Version : 9.0.1.1.2 <-----> 7.3.4 <-----> 7.3.4 plus run catexp.sql


Export From <-----> Import to <-----> Use Import/Export Utility
Version : 8.1.7.4 <-----> 8.0.6 <-----> 8.0.6



Export From <-----> Import to <-----> Use Import utility
Version : 8.1.7.4 <-----> 10.2.0.1.0 <-----> 10.2.0.1.0
Version : 9.0.1.1.2
Version : 9.2.0.1.0
Version : 10.1.0.2.0
Version : 10.2.0.1.0

Export From <-----> Import to <-----> Use Import utility
Version : 8.1.7.4 <-----> 9.2.0.1.0 <-----> 9.2.0.1.0
Version : 9.0.1.1.2
Version : 9.2.0.1.0

Export From <-----> Import to <-----> Use Import utility
Version : 8.1.7.4 <-----> 9.0.1.1.2 <-----> 9.0.1.1.2
Version : 9.0.1.1.2

Above procedure and table is best practice to export and import but also consider below case.

Dumpfile exported in Oracle 11gr1

Import in 10gr1, 9i, 8i

Then use Oracle 11gr1 client (IMPORT) binary to export 11g dumpfile.

Install oracle 11g client and connect to 10g,9i,8i server and import.

Dumpfile exported in Oracle 10g

Import in 9i,8i

Then use Oracle 10g client (IMPORT) binary to export 10g dumpfile

Install oracle 10g client and connect to 9i,8i server and import.

Dumpfile exported in Oracle 9i

Import in 8i

Then use Oracle 9i client (IMPORT) binary to export 9i dumpfile

Install oracle 9i client and connect to 8i server and import.

 

http://blogold.chinaunix.net/u2/86621/showart_1867527.html

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

上一篇: 有点乱
下一篇: ORA-09925 ,ORA-27086
请登录后发表评论 登录
全部评论

注册时间:2009-10-27

  • 博文量
    132
  • 访问量
    243860