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