| 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 |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
