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

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

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:42

ORA-14161：子分区号字符串：PCTUSED和PCTFREE的总和不能超过100,
.原因：在此消息中显示其子编号（子分区编号从1开始）的子分区的PCTUSED和PCTFREE的总和超过100.请注意，如果未明确指定此子分区的PCTUSED和/或PCTFREE值，则分区-level将被使用。如果未指定分区级别的默认PCTUSED和/或PCTFREE值，则将使用分区表或索引的默认值。如果没有明确指定这些值，将使用系统默认值。,
.行动：确保子分区的PCTUSED和PCTFREE的总和不超过100,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题