Home » RDBMS Server » Server Administration » Database shifting from UNIX to WINDOWS (Oracle 10g, Suse LINUX, WINDOWS)
Database shifting from UNIX to WINDOWS [message #375890] Mon, 15 December 2008 04:48 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Hi,
We have a production server located at Suse UNIX.

We would like to move database from UNIX to WINDOWS.
I would like to know what are the difficulties/scenarios which occures while moving the database?

How difficult is it to import current oracle database to oracle on windows server ?

Please explain in details.

Thanks,
Re: Database shifting from UNIX to WINDOWS [message #375895 is a reply to message #375890] Mon, 15 December 2008 05:11 Go to previous messageGo to next message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
You need setup the detailed procedure yourself by moving a test database from Unix to Windows. Just remember that you cannot use backup/restore, but export/import or transportable tablespaces should work just fine.

PS: Why do you want to run on Windows anyway? Isn't Unix a superior server operating system?
Re: Database shifting from UNIX to WINDOWS [message #375899 is a reply to message #375890] Mon, 15 December 2008 05:17 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Oracle database version is - Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Can anybody provide me the standard procedure note so that i can go through it?

Actually this is client requirenemt thats why need to move from unix to windows Sad
Thanks,

[Updated on: Mon, 15 December 2008 05:18]

Report message to a moderator

Re: Database shifting from UNIX to WINDOWS [message #375901 is a reply to message #375899] Mon, 15 December 2008 05:22 Go to previous message
Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Can anybody provide me the standard procedure note so that i can go through it?

Frank Naude wrote on Mon, 15 December 2008 12:11
export/import or transportable tablespaces should work just fine.

Isn't this the answer?
More details in the documentation that you have to study and test to design a correct migration for your environment.

Regards
Michel

Previous Topic: Installation of Oracle 9i on Windows laptop
Next Topic: Get size of the Perticular User
Goto Forum:
  


Current Time: Fri Jul 05 06:31:59 CDT 2024