Oracle DBA, How To, Error, Cause and Action

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

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)