Oracle Error ORA-14619: resulting List subpartition(s) must contain at least 1 value

Oracle Error Message

ORA-14619: resulting List subpartition(s) must contain at least 1 value

Reason for the Error

After a SPLIT/DROP VALUE of a list subpartition, each resulting subpartition(as applicable) must contain at least 1 value

Solution

Ensure that each of the resulting subpartitions contains atleast 1 value