Home » RDBMS Server » Server Administration » Migrating Database from Windows to Linux (Oracle 10 R1, Windows XP and Oracle Enterprise Linux AS 5)
Migrating Database from Windows to Linux [message #306474] Fri, 14 March 2008 07:56 Go to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Hi Experts,

Actually, I've gone through some topics in the forum relating to this but I am not satisfied enough.

Could you please if possible give me steps in migrating Oracle10g R1 on my Windos XP to Linux AS5 running Oracle10g R2.


Thanks in good anticipation.

Cherish
Re: Migrating Database from Windows to Linux [message #306475 is a reply to message #306474] Fri, 14 March 2008 08:03 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Three basic steps :

- Install Oracle on Linux
- Create the target database and the table spaces
- Export from source / Import on target
Re: Migrating Database from Windows to Linux [message #306477 is a reply to message #306475] Fri, 14 March 2008 08:11 Go to previous messageGo to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Thanks so much.

I already have Oracle on my Linux server. Is is that straight?
Re: Migrating Database from Windows to Linux [message #306480 is a reply to message #306477] Fri, 14 March 2008 08:27 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Then you can continue with step2, creating an empty database, with the same tablespaces as the original one.
Re: Migrating Database from Windows to Linux [message #306570 is a reply to message #306474] Fri, 14 March 2008 13:20 Go to previous message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
Additionally, you might want to look into transportable tablespace. I am not sure if it was 10g release 1 or 2 that allowed cross platform transportable tablespaces.
Previous Topic: Experimenting with the continous log mining
Next Topic: 'SYS' User login error
Goto Forum:
  


Current Time: Thu Dec 08 12:09:36 CST 2016

Total time taken to generate the page: 0.07495 seconds