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

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


Cause:


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



Action:


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