Home » RDBMS Server » Server Utilities » Import 10i into 9i
Import 10i into 9i [message #288045] Fri, 14 December 2007 08:23 Go to next message
e3339
Messages: 11
Registered: May 2007
Junior Member
Hello,

Is it possible to import a 10i export file into a 9i DB? The export from the 10i DB is just objects and data. Is there any Oracle OS backwards compatibiloty issues? Both are 32 bit version of Oracle.
Re: Import 10i into 9i [message #288049 is a reply to message #288045] Fri, 14 December 2007 08:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Only if you use a 9i exp binary to export your 10g database.

Regards
Michel
Re: Import 10i into 9i [message #288278 is a reply to message #288045] Sun, 16 December 2007 22:12 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

What do you mean by 10i? Exp/Imp version is needed to be care of.
Re: Import 10i into 9i [message #288287 is a reply to message #288045] Sun, 16 December 2007 22:44 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

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
Version : 10.2.0.1.0 <-----> 8.1.7 <-----> 8.1.7
Version : 10.2.0.1.0 <-----> 8.0.6 <-----> 8.0.6

Note : 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 binary for export data from 10.2.0.1.0.
and run CATEXP.SQL script.
Located : $ORACLE_HOME/rdbms/admin

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

http://dbataj.blogspot.com/2007/04/imp-00010.html

[Updated on: Sun, 16 December 2007 22:47]

Report message to a moderator

Previous Topic: Remote export
Next Topic: Full DB Export Session Hanged
Goto Forum:
  


Current Time: Fri Dec 09 04:15:49 CST 2016

Total time taken to generate the page: 0.10724 seconds