Home » Infrastructure » Unix » how to move database
how to move database [message #158346] Fri, 10 February 2006 01:45 Go to next message
aguil001
Messages: 1
Registered: February 2006
Junior Member
I need to move 40 databases from HPUX 11i to Sun Solaris 9. Could I install the Oracle software on the SUN and copy the Oracle datafiles/controlfiles, etc. from the HP machine to the SUN and simply start the database?

Report message to a moderator

Re: how to move database [message #158387 is a reply to message #158346] Fri, 10 February 2006 06:25 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
no.
When different OS is involved, Export/import is the only way.
If you are dealing with just one or two databases and want to minimize the downtime, you can use materialized views.
But in this case, export/import ***seems*** to be only option.

Report message to a moderator

Re: how to move database [message #158405 is a reply to message #158346] Fri, 10 February 2006 10:42 Go to previous message
vbob
Messages: 8
Registered: January 2006
Junior Member
If you are running 10g you could use convert feature to transport tablespaces accross platforms

Vadim Bobrov
Oracle Database Tools
http://www.fourthelephant.com

Report message to a moderator

Previous Topic: Creating A New Database From An Existing One?
Next Topic: Delete an oracle instance
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 21 11:46:50 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.