How to fix the Oracle error ORA-36673: (XSDPART11) Use simple leaf values to identify concat dimension values in a VALUES LESS THAN clause, rather than the format.?

In this post, you’ll learn more about the Oracle ErrorORA-36673: (XSDPART11) Use simple leaf values to identify concat dimension values in a VALUES LESS THAN clause, rather than the format. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-36673: (XSDPART11) Use simple leaf values to identify concat dimension values in a VALUES LESS THAN clause, rather than the format.

Reason for the Error ORA-36673: (XSDPART11) Use simple leaf values to identify concat dimension values in a VALUES LESS THAN clause, rather than the format.

When defining a RANGE partition template with a concat dimension for the partition dimension, the user attempted to define a range using the format of a concat dimension value.

How to fix the Error ORA-36673: (XSDPART11) Use simple leaf values to identify concat dimension values in a VALUES LESS THAN clause, rather than the format. ?

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

Use just the leaf value. Instead of “VALUES LESS THAN “, just say, “VALUES LESS THAN value”.