In this post, you’ll learn more about the Oracle ErrorORA-14635: only one resulting subpartition can be specified for MERGE SUBPARTITIONS with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-14635: only one resulting subpartition can be specified for MERGE SUBPARTITIONS
Reason for the Error ORA-14635: only one resulting subpartition can be specified for MERGE SUBPARTITIONS
ALTER TABLE MERGE SUBPARTITIONS contained more than one resulting subpartition for the MERGE
How to fix the Error ORA-14635: only one resulting subpartition can be specified for MERGE SUBPARTITIONS ?
You can fix this error in Oracle by following the below steps
Ensure that the statement describes exactly one subpartition as the target that need to be MERGEd