ORA-14058: partition number string: INITRANS value must be less than MAXTRANS value

ORA-14058: partition 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 partition whose number (partitions are numbered starting with 1) is displayed in this message. Note that if INITRANS and/or MAXTRANS values for this partition were not specified explicitly, default values for the partitioned table or index would be used. If, in turn, default INITRANS and/or MAXTRANS values for the partitioned table or index were not specified, system defaults would be used.
Action: ensure that value of INITRANS (whether specified explcitly or derived from the default value for the partitioned table or index) is no greater than that of MAXTRANS

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:41

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

aiaiDBA

13718043309

010-86462881

ORA-14058: partition number string: INITRANS value must be less than MAXTRANS value

1 个回答

相似问题