ORA-14161: subpartition number string: sum of PCTUSED and PCTFREE may not exceed 100 ORACLE 报错 故障修复

文档解释

ORA-14161: subpartition number string: sum of PCTUSED and PCTFREE may not exceed 100

Cause: the sum of PCTUSED and PCTFREE for a subpartition whose number (subpartitions are numbered starting with 1) is displayed in this message exceeds 100. Note that if PCTUSED and/or PCTFREE values for this subpartition were not specified explicitly, default values at partition-level would be used. If, in turn, default PCTUSED and/or PCTFREE values at partition-level were not specified, default values for the partitioned table or index would be used. If those values were also not specified explicitly, system defaults would be used.

Action: ensure that a sum of PCTUSED and PCTFREE for the subpartition does not exceed 100

ORA-14161错误指示将分区或子分区的PCTUSED和PCTFREE相加的和超过了100，表明您尝试使用不正确的设置来指定PCTUSED和/或PCTFREE。

官方解释

ORA-14161：子分区编号字符串：PCTUSED和PCTFREE之和不能超过100

该错误可以指出已超出子分区或者分区的PCTUSED和PCTFREE之和超过了最大值100。

常见案例

比如，如果设置了分段的PCTUSED为50，而将PCTFREE设置为60，则可能会收到此错误消息。

正常处理方法及步骤

1、检查是否将PCTUSED和PCTFREE之间的值设置为大于100，否则该错误会发生。

2、修改PCTUSED和PCTFREE的值，使它们的和小于等于100。

3、尝试重新提交表定义。