ORA-08111: a partitioned index may not be coalesced as a whole

Cause: User attempted to coalesce a partitioned index using ALTER INDEX COALESCE statement, which is illegal

Action: Coalesce the index a (sub)partition at a time (using ALTER INDEX MODIFY (sub)PARTITION COALESCE)

Error Type: ORA

• Additional information for ORA-08111: a partitioned index may not be coalesced as a whole08111
Discussions and solutions for Oracle Database Error ORA-08111: a partitioned index may not be coalesced as a whole Developer anwers for Oracle Database Error ORA-08111: a partitioned index may not be coalesced as a whole FAQs for ORA-08111: a partitioned index may not be coalesced as a whole search others tips for ORA-08111: a partitioned index may not be coalesced as a whole