Re: Migrating large database between platforms: using snapshots

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Mon, 2 Oct 2006 15:55:08 GMT
Message-ID: <J6IMvx.7qr@igsrsparc2.er.usgs.gov>

> 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.

It sounds to me like you are looking for a magic bullet here. You can't instantaneously transport data from one server to another. Some time will be required.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Mon Oct 02 2006 - 10:55:08 CDT