Oracle Error ORA-14314: resulting List partition(s) must contain atleast 1 value

Oracle Error Message

ORA-14314: resulting List partition(s) must contain atleast 1 value

Reason for the Error

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

Solution

Ensure that each of the resulting partitions contains atleast 1 value