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

Oracle Error Message

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

Reason for the Error

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

Solution

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