How to fix the Oracle error ORA-14031: partitioning column may not be of type LONG or LONG RAW?

In this post, you’ll learn more about the Oracle ErrorORA-14031: partitioning column may not be of type LONG or LONG RAW with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-14031: partitioning column may not be of type LONG or LONG RAW

Reason for the Error ORA-14031: partitioning column may not be of type LONG or LONG RAW

Partitioning column specified by the user was of type LONG or LONG RAW, which is illegal.

How to fix the Error ORA-14031: partitioning column may not be of type LONG or LONG RAW ?

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

Ensure that no partitioning column is of type LONG or LONG RAW.