OraFAQ Forum: Backup & Recovery » Migration of Solaris Oracle9i to Windows Oracle9i

Home » RDBMS Server » Backup & Recovery » Migration of Solaris Oracle9i to Windows Oracle9i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Migration of Solaris Oracle9i to Windows Oracle9i [message #190986]

Sun, 03 September 2006 22:25

kklam
Messages: 1
Registered: September 2006

Junior Member

Hi all,

I have a running Oracle9i installed in Solaris10. I need to port the whole database over to another instance of Oracle9i in Windows. I have tried various ways like export and import but failed. Is there any other recommended ways? Thanks for any help rendered.

[Updated on: Sun, 03 September 2006 22:25]

Report message to a moderator

Re: Migration of Solaris Oracle9i to Windows Oracle9i [message #190987 is a reply to message #190986]

Sun, 03 September 2006 22:41

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> I have tried various ways like export and import but failed
How exactly?
Unfortunately, there is not much you can do here.
Export/import is the only method (easy, straight forward and affordable if the volume of data is not very high) when you are migrating between different operating systems (or you should have already been using transportable tablespaces).
Other method is to employ materialzed views, which is ideal if you want to minimize the downtime (but will take significant effor set up)

[Updated on: Sun, 03 September 2006 22:42]

Report message to a moderator

Re: Migration of Solaris Oracle9i to Windows Oracle9i [message #191292 is a reply to message #190986]

Tue, 05 September 2006 09:00

email.sandeepnaik
Messages: 121
Registered: August 2006

Senior Member

you can also consider "copy" command via sqlplus if data is small and have handful of objects.
However, copy will just help in getting table data copied, rest (index, procedures, functions etc. ) needs to be brought over manually or via exp/imp.

Sandeep

Report message to a moderator

Re: Migration of Solaris Oracle9i to Windows Oracle9i [message #191346 is a reply to message #190986]

Tue, 05 September 2006 16:19

kimant
Messages: 201
Registered: August 2006
Location: Denmark

Senior Member

You could perhaps benefit from this:
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:6267652535905

Br
Kim

Report message to a moderator

Previous Topic:	How to backup incremental backup
Next Topic:	Backup database using RMAN Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 16 03:31:09 CDT 2025