Re: partitions : truncate/rename OR drop/recreate

Thanks both for the input - very much appreciated !!!!

regards,
Kurt

"koert54" <k_at_k.com> wrote in message
news:AsE%6.5473$YS5.595566_at_afrodite.telenet-ops.be...
> Hi,
>
> We're going to implement a partitioned table containing historical data.
 The
> table will contain 24 months of data - or 24 partitions. Now as we roll
 over
> and start storing our '25th' month of
> data, what is the best way handle this :
> 1. drop the oldest partition and recreate it
> 2. truncate the oldest partition and rename it
>
> I know that if you drop a partition you'll invalidate any global index and
> any local index will also
> be dropped ... but beside that, are there any other consequences I should
> keep an eye on ?
>
> Kind Regards,
> Kurt
>
>
>
Received on Sun Jul 01 2001 - 16:45:52 CDT