Oracle Solution for Error ora-36671

ORA-36671: (XSDPART09) Leaves of workspace object

have different datatypes. A partition dimension cannot have more than one datatype when RANGE partitioning is used.

What triggered 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.

What should we do to fix it:

Pick a different partition dimension.