| Import 10i into 9i [message #288045] |
Fri, 14 December 2007 08:23  |
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 #288287 is a reply to message #288045] |
Sun, 16 December 2007 22:44  |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
