How to fix the Oracle error ORA-36672: (XSDPART10) A RANGE or LIST PARTITION TEMPLATE can only have a single partition dimension.?

In this post, you’ll learn more about the Oracle ErrorORA-36672: (XSDPART10) A RANGE or LIST PARTITION TEMPLATE can only have a single partition dimension. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-36672: (XSDPART10) A RANGE or LIST PARTITION TEMPLATE can only have a single partition dimension.

Reason for the Error ORA-36672: (XSDPART10) A RANGE or LIST PARTITION TEMPLATE can only have a single partition dimension.

User attempted to define a RANGE or LIST partition template with more than one partition dimension.

How to fix the Error ORA-36672: (XSDPART10) A RANGE or LIST PARTITION TEMPLATE can only have a single partition dimension. ?

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

Remove all but one of the dimensions from the PARTITION BY RANGE(…) or PARTITION BY LIST(…) clause of the partition template definition.