PARTITION IN LOB COLUMNS
Can we use partitioning key as LOB column in a partitioned table or during partitioned table creation?
No, LOB columns cannot be used as partitioning key but table containing LOB columns can be partitioned with non-LOB column as partitioning key.
ERROR at line 6:
ORA-14135: a LOB column cannot serve as a partitioning column
SQL> !oerr ora 14135
14135, 00000, "a LOB column cannot serve as a partitioning column"
// *Cause: An attempt was made to specify a column of type BLOB or CLOB as a
// partitioning or subpartitioning column.
// *Action: Ensure that no partitioning or subpartitioning column is of type
// BLOB or CLOB.
All types of partitions are supported for table’s with LOB columns like range, list, hash, composite etc..