Oracle Error ORA-36681: (XSDPART19) Partitions string and string are out of order.

Oracle Error Message

ORA-36681: (XSDPART19) Partitions string and string are out of order.

Reason for the Error

In the definition of a range partition template, a partition with a lower range boundary was listed after a partition with a higher range boundary.

Solution

Alter the order of the partition definition list.