Oracle Error ORA-36686: (XSDPART24) Value number is not in partition number.

Oracle Error Message

ORA-36686: (XSDPART24) Value number is not in partition number.

Reason for the Error

User attempted to reorganize a list partition template by removing a value from some partition’s list, but the value was not in the list.

Solution

Ensure that the given values match the given partition.