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

IMG-00578: missing quantize argument

1 Answers  


NZE-28760: list creation failure

1 Answers  


DRG-12202: error while creating section group

1 Answers  


ORA-12032: cannot use rowid column from materialized view log on "string"."string"

1 Answers  


ORA-14126: only a <parallel clause> may follow description(s) of resulting partitions

1 Answers  






ORA-02045: too many local sessions participating in global transaction

1 Answers  


TNS-00222: -------------------------------------------------------------------

1 Answers  


ORA-07480: snchmod: cannot change permissions on ?/dbs/sgalm.dbf.

1 Answers  


ORA-31208: DBMS_LDAP: PL/SQL - Invalid LDAP Message.

1 Answers  


ORA-08182: operation not supported while in Flashback mode

1 Answers  


ORA-29953: cannot issue DDL on a domain index partition marked as FAILED

1 Answers  


NNL-00566: set|show log_file_name [<filename>] [<server_list>] : set|show the log file name on one or more servers

1 Answers  


Categories