Home » RDBMS Server » Server Administration » Database copy on different OS
Database copy on different OS [message #63841] Mon, 15 November 2004 23:11 Go to next message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
How can I copy my database from Unix OS to NT environment. Can I copy datafiles directly if yes How or Export/Import Option can be used.

sanjay

Report message to a moderator

Re: Database copy on different OS [message #63842 is a reply to message #63841] Mon, 15 November 2004 23:57 Go to previous messageGo to next message
dilip kumar
Messages: 111
Registered: December 2003
Senior Member
Hi

it's depand on your size of database....and morever i guess u can't transport a tablespace from one database to another if it is having different O/S...if it is same O/S you can do that..but here also you will have one complication when you transport system tablespace to another database....So use export/import option...

Regards

D.Dilip

Report message to a moderator

Re: Database copy on different OS [message #63843 is a reply to message #63841] Tue, 16 November 2004 03:57 Go to previous messageGo to next message
croK
Messages: 170
Registered: April 2002
Senior Member
You can't.
No possibility to copy files directly between different platforms.
You must create database on NT, full export from unix, then full import on new NT database.

Best luck.
Remote DBA looking for remote job.

Report message to a moderator

Re: Database copy on different OS [message #63851 is a reply to message #63843] Tue, 16 November 2004 20:54 Go to previous message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
Hi,

But if you are using oracle 10g then you can. In 10g you can transport tablespaces across the platforms using RMAN. Refer Oracle Doc for more info.

Daljit Singh.

Report message to a moderator

Previous Topic: URGENT:oracle 10g corrupted
Next Topic: oracle 92
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 09 22:38:46 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.