About partitioning and undo

Hello all,

I'm writing a rollover script for a partitioned table, that basically creates a new partition and deletes the oldest one. I thought I'd simply issue an "alter table drop partition" statement, but a colleague claims it's better to truncate before dropping to make it faster. Now, AFAIK the drop does not generate undo/redo info except for the dictionary bit, so I see no point in truncating before dropping. What do you think?

TIA Stefano Received on Fri Oct 14 2005 - 05:54:15 CDT