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

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


Cause:


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



Action:


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