About partitioning and undo

[SR]

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

[MTNorman]

Stefano,

Do you have global indexes or are all indexes local? If all indexes
are local then "drop partition" will work fine. If you have a global
index, then truncating the partition first may work better.

Regards,
Margaret

[Anurag Varma]

"May work better"?

Maybe not?

Are we dealing with lotto here or do we have reasons why?

Anurag