ORA-14163: subpartition number string: INITRANS value must be less than MAXTRANS value

ORA-14163: subpartition number string: INITRANS value must be less than MAXTRANS value
Cause: Value of INITRANS was found to be greater than that of MAXTRANS for a subpartition whose number (subpartitions are numbered starting with 1) is displayed in this message. Note that if INITRANS and/or MAXTRANS values for this subpartition were not specified explicitly, default values at partition-level would be used. If, in turn, default INITRANS and/or MAXTRANS 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 value of INITRANS (whether specified explicitly or derived from the default value at partition-level, table-level or index-level) is no greater than that of MAXTRANS

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:42

ORA-14163：子分区号字符串：INITRANS值必须小于MAXTRANS值,
.原因：发现INITRANS的值大于MAXTRANS的值，该子分区的编号（子分区编号从1开始）显示在此消息中。请注意，如果未明确指定此子分区的INITRANS和/或MAXTRANS值，则将使用分区级别的默认值。如果未指定分区级别的缺省INITRANS和/或MAXTRANS值，则将使用分区表或索引的缺省值。如果没有明确指定这些值，将使用系统默认值。,
.操作：确保INITRANS的值（无论是明确指定还是从分区级，表级或索引级的缺省值派生）不大于MAXTRANS的值,
.

aiaiDBA

13718043309

010-86462881

ORA-14163: subpartition number string: INITRANS value must be less than MAXTRANS value

1 个回答

相似问题