How to fix the 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.?

In this post, you’ll learn more about the Oracle ErrorORA-36671: (XSDPART09) Leaves of workspace object have different datatypes. A partition dimension cannot have more than one datatype when RANGE partitioning is used. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

How to fix the 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. ?

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

Pick a different partition dimension.