ORA-14135: a LOB column cannot serve as a partitioning column

文档解释

ORA-14135: 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.

ORA-14135:是指不能将LOB字段用作分区列。

官方解释

常见案例

正常处理方法及步骤

1)确认表或者分区中是否存在LOB字段作为分区列。

2)将LOB字段从分区列中移除或者替换,并且使用其它字段作为分区列,并保证partitioning方式不变。

3)重新执行添加分区的操作,如果出现错误,请检查相关错误及资料。

你可能感兴趣的