How to fix the Oracle error ORA-36681: (XSDPART19) Partitions string and string are out of order.?

In this post, you’ll learn more about the Oracle ErrorORA-36681: (XSDPART19) Partitions string and string are out of order. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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.

How to fix the Error ORA-36681: (XSDPART19) Partitions string and string are out of order. ?

You can fix this error in Oracle by following the below steps

Alter the order of the partition definition list.