Oracle Error ORA-14635: only one resulting subpartition can be specified for MERGE SUBPARTITIONS

Oracle Error Message

ORA-14635: only one resulting subpartition can be specified for MERGE SUBPARTITIONS

Reason for the Error

ALTER TABLE MERGE SUBPARTITIONS contained more than one resulting subpartition for the MERGE

Solution

Ensure that the statement describes exactly one subpartition as the target that need to be MERGEd