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命令,如果没有报错,则表示修改成功。