Oracle Error Message
ORA-14640: add/coalesce index partition operation is valid only for hash partitioned global indexes
Reason for the Error
User attempted to add or coalesce an index partition of a global index not partitioned by hash method.
Solution
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.