Database Error Messages

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

ORA-14640

add/coalesce index partition operation is valid only for hash partitioned global indexes

Cause

User attempted to add or coalesce an index partition of a global index not partitioned by hash method.


Action

Issue the statement on a global index partitioned by hash method. or if the index is partitioned by range method consider using split/drop instead of add/coalesce.