Home » RDBMS Server » Server Administration » transfer datafiles across o/s platform
transfer datafiles across o/s platform [message #51766] Wed, 12 June 2002 16:22 Go to next message
Erin Nickerson
Messages: 1
Registered: June 2002
Junior Member
I need to restore a database from a Unix AIX platform to a WIndows 2000 platform. ORacle version is the same 8.1.6 Can I just use the datafiles from the unix machine and copy to the Windows machine? Not enough space on original machine and no others avaialable ! Help!

Report message to a moderator

Re: transfer datafiles across o/s platform [message #51768 is a reply to message #51766] Wed, 12 June 2002 17:25 Go to previous messageGo to next message
tommy
Messages: 22
Registered: July 2000
Junior Member
No, the file headers are different between the 2 platforms. Your best bet would be to export from the old and import into the new.

good luck

Report message to a moderator

Re: transfer datafiles across o/s platform [message #51788 is a reply to message #51766] Thu, 13 June 2002 11:32 Go to previous messageGo to next message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
No, you can not do that. File systems are different.

Cloning database on different platform could be done either by export/import or RMAN cloning. Check the RMAN docs for more details.

Hope that helps,

OCP DBA
visit our web site: Visit our web site [url=http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi]Click Here

Report message to a moderator

Re: transfer datafiles across o/s platform [message #51800 is a reply to message #51766] Thu, 13 June 2002 16:25 Go to previous message
Marc
Messages: 26
Registered: August 1999
Junior Member
The 9i RMAN manuals say this is NOT possible.

Unless I'm missing something....

Report message to a moderator

Previous Topic: Cursor Values
Next Topic: Oracle Recovery Problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 25 19:24:31 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.