Re: Convert table into partitioned table (Fast)
Date: Thu, 6 Mar 2008 20:14:26 -0800 (PST)
> 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