partitions : truncate/rename OR drop/recreate

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 - 07:12:16 CDT