| oracle database migration [message #408030] |
Sat, 13 June 2009 02:14  |
oradba123
Messages: 18
Registered: June 2009
Location: india |
Junior Member |
|
|
Hi experts,
our prod database is oracle 9.2 on windows 2000 server and my manager need to make a copy of that database on ibm aix 4.3 with oracle version 8.1.7, so installed oracle 8.1.7 on aix 4.3 and create the database on it with same name as i have on my prod and create all tablepace associated datafiles and i expoted full prod database, but my question is can we migrate from oracle 9.2 to 8.1.7 becuase we undo segments in oracle 9i but we don't undo segments in oracle 8.1.7 instead of that we have roll back segments.any one have idea about that.please reply me soon .quick reponse will be higly appreciated.thanks a lot in advance.
|
|
|
| Re: oracle database migration [message #408031 is a reply to message #408030] |
Sat, 13 June 2009 02:23  |
Michel Cadot
Messages: 28993
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
You don't migrate, you export and import users objects and data. So yes, you can, you just have to use 8i exp to export.
Of course, if you use in your 9i database some kind of datatypes that don't exits in 8i (like timestamp) this will not work.
Regards
Michel
|
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
