Oracle Error ORA-14285: cannot COALESCE the only partition of this hash partitioned table or index

Oracle Error Message

ORA-14285: cannot COALESCE the only partition of this hash partitioned table or index

Reason for the Error

A COALESCE PARTITION command was issued when there is only one partition in the table or index, which is illegal

Solution

Ensure that there is at least one partition. Drop the table or index to remove all partitions.