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



ORA-14161: subpartition number string: sum of PCTUSED and PCTFREE may not exceed 100..

Answer / guest

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.

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-07610: $GETJPIW failed in retrieving the user's MAC priviledges

1 Answers  


ORA-13028: Invalid Gtype in the SDO_GEOMETRY object

2 Answers  


ORA-37131: (XSCCOMP06) Cannot aggregate VARIABLE workspace object using AGGMAP workspace object because the OPERATOR string is not supported for bases of a COMPRESSED COMPOSITE.

1 Answers  


ORA-16064: remote archival is disabled by another instance

1 Answers  


ORA-01563: rollback segment is PUBLIC, need to use the keyword PUBLIC

1 Answers  






ORA-02853: Invalid server list latch time out value

1 Answers  


ORA-13365: layer SRID does not match geometry SRID

1 Answers  


RMAN-06530: CHANGE ... KEEP not supported for backup set which contains archive logs

1 Answers  


PCC-01301: Your Pro*PL/I authorization is about to expire

1 Answers  


ORA-38733: Physical size string less than needed string.

1 Answers  


ORA-22601: pickler TDS context [string] is not initialized

1 Answers  


ORA-30443: definition for filter string's item string is invalid

1 Answers  


Categories