subpartition number string: sum of PCTUSED and PCTFREE may not exceed 100

Solution ID:ORA-14161

Type: Oracle

Cause

the sum of PCTUSED and PCTFREE for a subpartition whose number (subpartitions are numbered starting with 1) is displayed in this message exceeds 100. Note that if PCTUSED and/or PCTFREE values for this subpartition were not specified explicitly, default values at partition-level would be used. If, in turn, default PCTUSED and/or PCTFREE 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

Reduce number of subpartitions to not exceed 1024K-1.

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