Oracle DB Error ORA-08111 a partitioned index may not be coalesced as a whole

The following is the cause of this error message:

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

Action you can take to resolve this issue: Coalesce the index a (sub)partition at a time (using ALTER INDEX MODIFY (sub)PARTITION COALESCE).

Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory

Related