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-02037: uninitialized speed bind storage

1 Answers  


ORA-07274: spdcr: access error, access to oracle denied.

2 Answers  


ORA-24317: define handle used in a different position

1 Answers  


ORA-23302: application raised communication failure during deferred RPC

1 Answers  


NZE-28786: decryption of encrypted private key failure

1 Answers  






LPX-00407: right square bracket missing in the XSL file

1 Answers  


ORA-14061: data type or length of an index partitioning column may not be changed

1 Answers  


PCC-02081: CMD-LINE: Unterminated option value list or value list was truncated.

1 Answers  


ORA-12591: TNS:event signal failure

1 Answers  


TNS-01442: No filtering rules currently in effect.

1 Answers  


ORA-17622: failed to deregister the memory with Oracle Disk Manager library

1 Answers  


NNF-04007: Error reading input file

1 Answers  


Categories