While performing an exp/imp operation , i got IMP-00010 while importing the dumps .On googling i found that this error occur generally due to two reasons .
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.
e.g; exp dump file is Oracle 10g and import in Oracle 9i
Export From <----> Import to <----> Use Import/Export Utility
Version : 10.2.0.1.0 <-----> 10.1.0.2.0 <-----> 10.1.0.2.0
Version : 10.2.0.1.0 <-----> 9.2 <-----> 9.2
Version : 10.2.0.1.0 <-----> 9.0.1 <-----> 9.0.1
Note : Suppose we want to import 10.2.0.1.0 export dump file in 9.2.0 then we must use 9.2.0 export tools for export data from 10.2.0.1.0. and run CATEXP.SQL script which is located in Located : $ORACLE_HOME/rdbms/admin
Consider an example : Dumpfile exported in Oracle 11gr1 and has to be Imported in 10gr1, 9i. Then use Oracle 11gr1 client (IMPORT) binary to export 11g dumpfile. Install oracle 11g client and connect to 10g,9i,8i server and import .
Enjoy :-)
3 comments:
Does it also mean that if I was to import into 10.2.0.1.0 from 10.2.0.4.0, I would need to use 10.2.0.1.0 on 10.2.0.4.0
Hi WenQiang SG
The 10.2.0.4.0 export dump can be imported into 10.2.0.1.0 . you need to use the Version parameter in your expdp statements and specify the version into which you want to import (in your case,it is 10.2.0.1.0) . For more details check the below link .
http://vishwanath-dbahelp.blogspot.in/2011/09/version-parameter-in-datapump.html
Hope this help you :-)
Regards
Neeraj
Post a Comment