Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-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)