Hi Ravi, > On 18. Nov, 2020, at 15:30, Ravi Krishna <srkrishna@xxxxxxxxx> wrote: > > ALTER TABLE TABLE_NAME DROP PARTITION PARTITION_NAME UPDATE INDEXES; IIRC the statement is alter table <table> drop partition <partition> update *GLOBAL* indexes; But we experienced big problems in the past which is why we changed all to local indexes. The situation may have improved in the last few years but we will not change back again. :-) Why should we? Cheers, Paul
