In this post, you’ll learn more about the Oracle ErrorORA-14135: a LOB column cannot serve as a partitioning column with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-14135: a LOB column cannot serve as a partitioning column
Reason for the Error ORA-14135: a LOB column cannot serve as a partitioning column
An attempt was made to specify a column of type BLOB or CLOB as a partitioning or subpartitioning column.
How to fix the Error ORA-14135: a LOB column cannot serve as a partitioning column ?
You can fix this error in Oracle by following the below steps
Ensure that no partitioning or subpartitioning column is of type BLOB or CLOB.