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

Oracle Error Message

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

Reason for the Error

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.

Solution

Modify the offending VALUES LESS THAN or VALUES phrase.