Oracle Solution for Error ora-36674

Solution for Oracle Error ORA-36674

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

.

What triggered 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.

What should we do to fix it:

Modify the offending VALUES LESS THAN or VALUES phrase.