subpartition "string": INITRANS value must be less than MAXTRANS value

Solution ID:ORA-14164

Type: Oracle

Cause

Value of INITRANS was found to be greater than that of MAXTRANS for a subpartition whose name (explicitly specified by the user) is displayed in this message. Note that if INITRANS and/or MAXTRANS values for this subpartition were not specified explicitly, default values at partition-level would be used. If, in turn, default INITRANS and/or MAXTRANS values at partition-level were not specified, default values for the partitioned table or index would be used. If those values were also not specified explicitly, system defaults would be used.

Actions

ensure that a sum of PCTUSED and PCTFREE for the subpartition does not exceed 100

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm


Browse all solutions to database errors from Oracle, MS SQL, or MySQL