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

Oracle Error Message

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

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.

Solution

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