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

PLS-01400: Use of '||' token

1 Answers  


ORA-10616: Operation not allowed on this tablespace

1 Answers  


ORA-02083: database name has illegal character 'string'

1 Answers  


ORA-35282: (SNSYN166) The format of the AGGREGATE function is: AGGREGATE(varname USING aggmap-name [COUNTVAR intvar-name] [FORCECALC])

1 Answers  


ORA-16793: Logical Standby Database Guard is unexpectedly OFF

1 Answers  






ORA-02362: error closing file: string

1 Answers  


ORA-12715: invalid character set specified

1 Answers  


PCC-02450: Cursor was not declared in scrollable mode

1 Answers  


ORA-14120: incompletely specified partition bound for a DATE column

1 Answers  


ORA-16109: failed to apply log data from previous primary

1 Answers  


PLS-01410: Use of 'MOD' token

1 Answers  


TNS-01070: Starting string: please wait...

1 Answers  


Categories