Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to migrate my oracle database to another server, pls

Re: How to migrate my oracle database to another server, pls

From: joel garry <joel-garry_at_home.com>
Date: 1 Aug 2006 16:43:01 -0700
Message-ID: <1154475780.990527.323640@s13g2000cwa.googlegroups.com>

Plactoon wrote:
> Hi everyone,
>
> I need to migrate an oracle database to another server, but keeping all
> equal, like a mirror, i have my original db in Solaris server, need to
> change it to windows 2000 server but, like i said, keeping all, table
> spaces, data....
>
> how can i do this?, or where can i find information about it?,
>
> I appreciate ur help,
>
> thx
>
> Plactoon

Is this something you are doing once or periodically? Why do you need to "mirror," what exactly does that mean and what are you going to do with it?

I had a similar situation where I had to sync nightly, the fastest simple way turned out to be CTAS over a dblink. But then again, I had a fast reliable network between the two, downtime during the night, and only a few dozen tables and gigabytes were actually being used.

jg

-- 
@home.com is bogus.
What?
Received on Tue Aug 01 2006 - 18:43:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US