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