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

文档解释

ORA-14059: partition “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 name (explicitly specified by the user) 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-14059 错误消息代表INITRANS 值必须小于MAXTRANS值。

官方解释

ORA-14059: partition “string”：INITRANS 值必须小于MAXTRANS 值

该错误是指在创建或修改分区表时，在指定INITRANS 保留最大事务数时，MAXTRANS 值不能小于INITRANS 值。

遇到该错误的常见情况：

1. 尝试在分区表中设置INITRANS 字段值比MAXTRANS 字段值大。

2. 在ALTER TABLE 语句中分区表指定INITRANS 字段值为大于MAXTRANS 字段值。

正常处理方法及步骤

（1）确认INITRANS 和MAXTRANS 的值是否正确：

确保INITRANS 的值不能超过MAXTRANS 的值，如下的例子：

CREATE TABLE tablename

(

col1 LEFT,

col2 INTEGER

)

PARTITION BY LIST (col2)

(

PARTITION p1 VALUES (1) INITRANS 5 MAXTRANS 10

);

（2）如果INITRANS 值大于MAXTRANS ，那么需要调整INITRANS 关键字定义的值，本例子中将INITRANS 的值改为4：

CREATE TABLE tablename

(

col1 LEFT,

col2 INTEGER

)

PARTITION BY LIST (col2)

(

PARTITION p1 VALUES (1) INITRANS 4 MAXTRANS 10

);