Home » RDBMS Server » Server Administration » oracle database migration (oracle 8.1.7,aix 4.3)
oracle database migration [message #408030] Sat, 13 June 2009 02:14 Go to next message
oradba123
Messages: 86
Registered: June 2009
Location: india
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.

Report message to a moderator

Re: oracle database migration [message #408031 is a reply to message #408030] Sat, 13 June 2009 02:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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

Report message to a moderator

Re: oracle database migration [message #408035 is a reply to message #408031] Sat, 13 June 2009 03:04 Go to previous messageGo to next message
oradba123
Messages: 86
Registered: June 2009
Location: india
Member


Hi,

thank you for quick reply but how do i use oracle 8.1.7 export utility to take export on oracle 9.2 database any idea about that.quick reply will be highly appreciated.

Report message to a moderator

Re: oracle database migration [message #408037 is a reply to message #408035] Sat, 13 June 2009 03:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Remote export from your 8i server or install a 8i client version on your 9i server.

Regards
Michel

Report message to a moderator

Re: oracle database migration [message #410553 is a reply to message #408035] Sun, 28 June 2009 10:01 Go to previous message
selvakumarmvs
Messages: 12
Registered: February 2009
Junior Member
Run oracle 8i the catexp8.sql script on oracle 9i...


see this

http://lbdwww.epfl.ch/f/teaching/courses/oracle9i/server.920/a96530/expimp.htm


Regards
selva..

Report message to a moderator

Previous Topic: Creating DataBase Manually (merged)
Next Topic: create new database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 22:34:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.