How to fix the Oracle error ORA-36668: (XSDPART06) string is not a legal RANGE partition.?

In this post, you’ll learn more about the Oracle ErrorORA-36668: (XSDPART06) string is not a legal RANGE partition. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-36668: (XSDPART06) string is not a legal RANGE partition.

Reason for the Error ORA-36668: (XSDPART06) string is not a legal RANGE partition.

User attempted to use CONCAT or LIST syntax in defining a RANGE partition template.

How to fix the Error ORA-36668: (XSDPART06) string is not a legal RANGE partition. ?

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

Use RANGE partition syntax.