Oracle Error ORA-14286: cannot COALESCE the only subpartition of this table partition

Oracle Error Message

ORA-14286: cannot COALESCE the only subpartition of this table partition

Reason for the Error

A COALESCE SUBPARTITION command was issued when there is only one subpartition in the partition which is illegal

Solution

Ensure that there is at least one subpartition. Drop partition to remove all subpartitions.