Re: Migrating large database between platforms: using snapshots

From: <ivl5_at_hotmail.com>
Date: 3 Oct 2006 22:26:51 -0700
Message-ID: <1159939611.807790.182500@b28g2000cwb.googlegroups.com>

Brian Peasland wrote:
> > Yes
> > I know that it is possible to use CREATE TABLE AS SELECT * to copy
> > tables from one database to another, but for 100+ GB table it will take
> > a while, even when done with parallel option, and then I'll have to
> > build indexes.
>
> Then how are snapshots or materialized views going to speed this up for
> you? If if you create a snapshot in a remote database, you're going to
> have to copy all of that data across the wire.

The goal is not to move data across as fast as possible. I think OP wants to minimise application downtime - shutdown apps and get it restarted with the new database asap.

Cheers,
Igor

> HTH,
> Brian
Received on Wed Oct 04 2006 - 00:26:51 CDT