OraFAQ Forum: Server Administration » How to migrate Oracle 8i to 10G on solaris

Home » RDBMS Server » Server Administration » How to migrate Oracle 8i to 10G on solaris

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to migrate Oracle 8i to 10G on solaris [message #144311]

Tue, 25 October 2005 20:52

evoradba
Messages: 144
Registered: April 2005
Location: Canada

Senior Member

Hello

Im planing a database upgrade from 8.1.7.4.0 to the latest 10G R2.
Has anyone done this? Can someone please help as how to do it?
Thank you so much
Maria

Report message to a moderator

Re: How to migrate Oracle 8i to 10G on solaris [message #144321 is a reply to message #144311]

Wed, 26 October 2005 00:18

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14238/toc.htm

Report message to a moderator

Re: How to migrate Oracle 8i to 10G on solaris [message #144753 is a reply to message #144321]

Fri, 28 October 2005 01:47

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi,

hey you can migrate 8i to 10g by Exp & imp utility.... just insatall 10g on new server where you want to migrate 8i data then simply do export from 8i and import to 10g.
Now question arises what you want to export ?
well you can export whole database ....
But it will be better if you export all schema seperatly and then import it one bye one on 10g...( It is time consuming but effective).

Export and import utility which you will use must be compatible with each other ... Smile

Regards
Always Friend sunilkumar

Report message to a moderator

Re: How to migrate Oracle 8i to 10G on solaris [message #144797 is a reply to message #144753]

Fri, 28 October 2005 06:54

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Sunil,
Export / Import will not always work.
If your database has simple data, it will.
If you are using something like Intermedia etc, there is a lot of changes internally and your data needs to migrated through the procedure.
Many features may be added and deprecated with each release.
And what happens to your code?
Export / import will not touch it.
I strongly recomend going through the upgrade document suggested by Tarun. Only after a good analysis you should decide on the method.

Report message to a moderator

Re: How to migrate Oracle 8i to 10G on solaris [message #144854 is a reply to message #144797]

Fri, 28 October 2005 10:51

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

Hi,

thank you for the information mahesh

Regards
always friend sunilkumar..

Report message to a moderator

Previous Topic:	Difference Magerly between Cat and Tab
Next Topic:	Index Option - Parallel

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 12:36:23 CST 2025