Oracle Error ORA-14211: subpartition bound must collate higher than that of the last subpartition

Oracle Error Message

ORA-14211: subpartition bound must collate higher than that of the last subpartition

Reason for the Error

Subpartition bound specified in ALTER TABLE MODIFY PARTITION ADD SUBPARTITION statement did not collate higher than that of the partition’s last subpartition.

Solution

Ensure that the subpartition bound of the subpartition to be added collates higher than that of the table partition’s last subpartition.