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-23335: priority group string already exists

1 Answers  


ORA-06921: CMX: getdatmsg illegal datatype

1 Answers  


ORA-00355: change numbers out of order

1 Answers  


TNS-00073: * stop/abort - stop the process_name

1 Answers  


QSM-01533: query rewritten with equivalence, string

1 Answers  






SQL*Loader-00961: Error calling once/load finishing for table string

1 Answers  


ORA-06037: NETDNT: connect failed, node unreachable

1 Answers  


ORA-13906: The tablepace is not of the right type.

1 Answers  


PCC-02066: CMD-LINE: Could not find or could not open system config file

1 Answers  


NNO-00602: warning: forwarder number has invalid address, forwarder ignored

1 Answers  


ORA-24388: Unsupported functionality in fast path mode

1 Answers  


LSX-00260: unexpected end of pattern

1 Answers  


Categories