Re: Convert table into partitioned table (Fast)

From: <mccmx_at_hotmail.com>
Date: Thu, 6 Mar 2008 20:14:26 -0800 (PST)
Message-ID: <d515e7d1-9d16-48ea-b804-dbc6f26b2d15@e23g2000prf.googlegroups.com>


> do a bunch of insert to
> select froms into tables with appropriate where clauses, and exchange
> each of those for partitions.  Not that I've ever tried it.
>

That sounds like a great idea..... That way I can do all of the loading into the tables up front, and then do the partition exchange during the outage window.

Thanks very much Received on Thu Mar 06 2008 - 22:14:26 CST

Original text of this message