Oracle Database 12c New Features

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

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