OraFAQ Forum: Server Utilities » Oracle migration from 8 to 11gR2

Home » RDBMS Server » Server Utilities » Oracle migration from 8 to 11gR2 (Oracle 8.0.5 Windows 2003)

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

Oracle migration from 8 to 11gR2 [message #475115]

Mon, 13 September 2010 02:11

s1970302
Messages: 6
Registered: November 2009
Location: seoul

Junior Member

I have Windows server working Oracle 8.0.5.
I have to migrate to another server that is Oracle 11gR2 on Windows 2008.
Some say I can't do Export and Import directly.
And some say DBlink is not working from 11Gr2 to 8.

What can be fewest step to migrate?
Somebody try to use 'Oracle directory' and VB and Powerbuilder program to send data and DDL from 8 to 11Gr2.
I didn't understand fully about this method.

What can be suggested migrating from Oracle 8.0.5 to 11Gr2 machine.
Thank you.

Report message to a moderator

Re: Oracle migration from 8 to 11gR2 [message #475120 is a reply to message #475115]

Mon, 13 September 2010 02:39

Michel Cadot
Messages: 54194
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Some say I can't do Export and Import directly.

This is wrong, you can, more it is the only way.

Quote:

And some say DBlink is not working from 11Gr2 to 8.

This is correct.

Quote:

What can be fewest step to migrate?

Follow Database Upgrade Guide.

Quote:

What can be suggested migrating from Oracle 8.0.5 to 11Gr2 machine

Export/import.

Regards
Michel

Report message to a moderator

Re: Oracle migration from 8 to 11gR2 [message #475440 is a reply to message #475120]

Wed, 15 September 2010 02:58

s1970302
Messages: 6
Registered: November 2009
Location: seoul

Junior Member

Xie Xie Thank you very much.
I might try each user export and import from 8 to 11gr2.

or
I might try Powerbuiler or VB program to migrate database,
in that case Oracle directory should be used.

How do you think?

Report message to a moderator

Re: Oracle migration from 8 to 11gR2 [message #475449 is a reply to message #475115]

Wed, 15 September 2010 04:02

joshanil
Messages: 1
Registered: September 2010
Location: Delhi

Junior Member

all senior member if i am wrong please correct me.

the world use Migration, as per my knowledge when we switch to one technology to other technology is migration like currently i am using sql server and now i want to transfer this server to Oracle so this term is Migration

but the question here is the person want to switch 8 to 10gr2 so the plateform is same "ORACLE", i think this term is "UPGRATION"

PLEASE HELP TO UNDERSTAND THESE TWO TERM

THANKS TO ALL Smile

Report message to a moderator

Re: Oracle migration from 8 to 11gR2 [message #475460 is a reply to message #475449]

Wed, 15 September 2010 04:33

Michel Cadot
Messages: 54194
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

There is no difference.
Before 10g, Oracle calls it "migration", starting from 10g it calls it "upgradation".

AND DO NOT POST IN UPPER CASE.

Regards
Michel

Report message to a moderator

Re: Oracle migration from 8 to 11gR2 [message #475791 is a reply to message #475460]

Fri, 17 September 2010 10:37

ThomasG
Messages: 2882
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Don't they call it "upgrade"?

"Upgrade" already is a noun, you don't have to add "ation" to turn it into one. ( pet peeve of mine, it drives me bonkers. ;-P )

Report message to a moderator

Re: Oracle migration from 8 to 11gR2 [message #475792 is a reply to message #475791]

Fri, 17 September 2010 10:50

Michel Cadot
Messages: 54194
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You're right! Thanks for the correction.

Regards
Michel

Report message to a moderator

Previous Topic:	Export Error
Next Topic:	Conflicting in parameters of export

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 22 14:12:07 CDT 2013

Total time taken to generate the page: 0.51303 seconds