ORA-14058: partition number string: INITRANS value must be less than MAXTRANS value ORACLE 报错 故障修复 远程处理

文档解释

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

ORA-14058是由于分区中INITRANS值大于MAXTRANS值导致的，它是Oracle数据库分区表段注释指令中出现的错误。

ORA-14058的官方解释是：

ORA-14058：分区编号字符串：INITRANS值必须小于MAXTRANS值

案例：

SQL> alter table user_data add partition p_2018_9 values less than (to_date(‘2018-10-01′,’yyyy-mm-dd’))

initrans 3 maxtrans 4

Table altered.

SQL>

执行上面的语句会导致ORA-14058错误，因为 maxtrans 参数的值比 initrans 参数的值要大。

正常处理方法及步骤

1. 使用 alter 命令调整 initrans 和 maxtrans 的值，满足 initrans 小于 maxtrans 的要求。

SQL> alter table user_data add partition p_2018_9 values less than (to_date(‘2018-10-01′,’yyyy-mm-dd’))

initrans 4 maxtrans 5

Table altered.

2. 再次运行alter命令，如果没有报错，则表示修改成功。