Hi Ravi,
> On 18. Nov, 2020, at 15:30, Ravi Krishna <srkrishna@yahoo.com> 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
improvedin the last few years but we will not change back again. :-) Why should we?
Cheers,
Paul