ORA-14162: subpartition "string": sum of PCTUSED and PCTFREE
may not exceed 100



ORA-14162: subpartition "string": sum of PCTUSED and PCTFREE may not exceed 100..

Answer / guest

Cause: the sum of PCTUSED and PCTFREE for a subpartition
whose name (explicitly specified by the user) 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-31653: unable to determine job operation for privilege check

1 Answers  


PLS-00539: subprogram 'string' is declared in an object type body and must be defined in the object type specification

1 Answers  


ORA-13265: geometry identifier column string in table string is not of type NUMBER

1 Answers  


LPX-00282: document cannot have both internal/external and shared DTDs

1 Answers  


ORA-07620: smscre: illegal database block size

1 Answers  


TNS-01025: Security string

1 Answers  


ORA-33261: (DBERRLEN) Analytic workspace string extension number truncated at number bytes while trying to read at number.

1 Answers  


ORA-02215: duplicate tablespace name clause

1 Answers  


NNL-00970: System query index number: number

1 Answers  


ORA-30741: WITH HIERARCHY OPTION can be specified only for SELECT privilege

1 Answers  


ORA-01618: redo thread string is not enabled - cannot mount

1 Answers  


RMAN-06124: error while looking up datafilecopy key: number

1 Answers  


Categories