Home » RDBMS Server » Server Utilities » Oracle migration from 8 to 11gR2 (Oracle 8.0.5 Windows 2003)
Oracle migration from 8 to 11gR2 [message #475115] Mon, 13 September 2010 02:11 Go to next message
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.
Re: Oracle migration from 8 to 11gR2 [message #475120 is a reply to message #475115] Mon, 13 September 2010 02:39 Go to previous messageGo to next message
Michel Cadot
Messages: 59731
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
Re: Oracle migration from 8 to 11gR2 [message #475440 is a reply to message #475120] Wed, 15 September 2010 02:58 Go to previous messageGo to next message
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?
Re: Oracle migration from 8 to 11gR2 [message #475449 is a reply to message #475115] Wed, 15 September 2010 04:02 Go to previous messageGo to next message
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



Re: Oracle migration from 8 to 11gR2 [message #475460 is a reply to message #475449] Wed, 15 September 2010 04:33 Go to previous messageGo to next message
Michel Cadot
Messages: 59731
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
Re: Oracle migration from 8 to 11gR2 [message #475791 is a reply to message #475460] Fri, 17 September 2010 10:37 Go to previous messageGo to next message
ThomasG
Messages: 3113
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 )
Re: Oracle migration from 8 to 11gR2 [message #475792 is a reply to message #475791] Fri, 17 September 2010 10:50 Go to previous message
Michel Cadot
Messages: 59731
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You're right! Thanks for the correction.

Regards
Michel
Previous Topic: Export Error
Next Topic: Conflicting in parameters of export
Goto Forum:
  


Current Time: Thu Nov 20 20:56:09 CST 2014

Total time taken to generate the page: 0.25899 seconds