Re: Convert table into partitioned table (Fast)
Date: Fri, 7 Mar 2008 11:53:25 +0100
<mccmx_at_hotmail.com> schreef in bericht
>> 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
You may be missing some records if they were inserted into the table between the up front loading and the partition exchange.... but if this is not the case, or not relevant, it may be worth while to try...
Shakespeare Received on Fri Mar 07 2008 - 04:53:25 CST