How to fix the Oracle error ORA-36674: (XSDPART12) Invalid dimension value starting at string.?

In this post, you’ll learn more about the Oracle ErrorORA-36674: (XSDPART12) Invalid dimension value starting at string. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-36674: (XSDPART12) Invalid dimension value starting at string.

Reason for the Error ORA-36674: (XSDPART12) Invalid dimension value starting at string.

When defining a RANGE or LIST partition template, the user specified an invalid value in a VALUES LESS THAN or VALUES clause. An “invalid value” can be one of two things: a value whose datatype does not match the partition dimension’s datatype, or a non-constant value.

How to fix the Error ORA-36674: (XSDPART12) Invalid dimension value starting at string. ?

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

Modify the offending VALUES LESS THAN or VALUES phrase.