Oracle Error ORA-14636: only 2 resulting subpartition can be specified for SPLIT SUBPARTITION

Oracle Error Message

ORA-14636: only 2 resulting subpartition can be specified for SPLIT SUBPARTITION

Reason for the Error

ALTER TABLE SPLIT SUBPARTITION contained more than 2 resulting subpartition for the SPLIT

Solution

Ensure that the statement describes exactly 2 subpartitions as the target of the SPLIT operation