ORA-14640: add/coalesce index partition operation is valid only for hash partitioned global indexes

oracle

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.

Back to previous menu