Home » RDBMS Server » Backup & Recovery » Migration of Solaris Oracle9i to Windows Oracle9i
Migration of Solaris Oracle9i to Windows Oracle9i [message #190986] Sun, 03 September 2006 22:25 Go to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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 Go to previous messageGo to next message
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
Re: Migration of Solaris Oracle9i to Windows Oracle9i [message #191346 is a reply to message #190986] Tue, 05 September 2006 16:19 Go to previous message
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
Previous Topic: How to backup incremental backup
Next Topic: Backup database using RMAN Error
Goto Forum:
  


Current Time: Wed Dec 07 09:00:32 CST 2016

Total time taken to generate the page: 0.08915 seconds