Re: Convert table into partitioned table (Fast)

From: <>
Date: Thu, 6 Mar 2008 20:14:26 -0800 (PST)
Message-ID: <>

> 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