Oracle Error ORA-14210: cannot reuse lower-bound subpartition as resulting subpartition

Oracle Error Message

ORA-14210: cannot reuse lower-bound subpartition as resulting subpartition

Reason for the Error

Attempted to reuse the lower-bound subpartition of the subpartitions being merged.

Solution

Specify new resulting subpartition name or reuse the higher-bound subpartition only