Hi Friends ,
I am using 10.2.0.4 oracle on solaris .
i have multiple partitioned local indexes from 2011 created on a daily basis . I tried to drop one of the indexes and got the below error .
SQL> ALTER INDEX QOSDEV.PK_RATE_CISCOMEMORYPOOL DROP PARTITION "05OCT2012"
ALTER INDEX QOSDEV.PK_RATE_CISMEPOOL DROP PARTITION "05OCT2012"
Error at line 2
ORA-14076: submitted alter index partition/subpartition operation is not valid for local partitioned index
Script Terminated on line 2.
I kindly request the way to drop these partitions .
Thanks ,
DBApps