Oracle Error ORA-36671: (XSDPART09) Leaves of workspace object have different datatypes. A partition dimension cannot have more than one datatype when RANGE partitioning is used.

Oracle Error Message

ORA-36671: (XSDPART09) Leaves of workspace object have different datatypes. A partition dimension cannot have more than one datatype when RANGE partitioning is used.

Reason for the Error

User attempted to define a range partition template with a concat partition dimension, and the concat had two leaf dimensions with different datatypes.

Solution

Pick a different partition dimension.