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

SQL*Loader-00646: lob set to EMPTY in column string, row number, table string

1 Answers  


ORA-39017: Worker request not supported when job is in string state.

1 Answers  


DRG-50937: query too complex

1 Answers  


ORA-01854: julian date must be between 1 and 5373484

1 Answers  


ORA-13858: Invalid action name

1 Answers  






ORA-23349: cannot generate replication support for functions

1 Answers  


ORA-12701: CREATE DATABASE character set is not known

1 Answers  


PLS-01405: Under ANSI's grammar, numeric data represented in exponent notationmust use an uppercase E

1 Answers  


ORA-12850: Could not allocate slaves on all specified instances: string needed, string allocated

1 Answers  


DRG-10703: invalid framework object string

1 Answers  


ORA-38739: Flashback log file is more recent than control file.

1 Answers  


ORA-25153: Temporary Tablespace is Empty

1 Answers  


Categories