ORA-14056: partition number string: sum of PCTUSED and
PCTFREE may not exceed 100



ORA-14056: partition number string: sum of PCTUSED and PCTFREE may not exceed 100..

Answer / guest

Cause: the sum of PCTUSED and PCTFREE for a partition whose
number (partitions are numbered starting with 1) is
displayed in this message exceeds 100. Note that if PCTUSED
and/or PCTFREE values for this partition were not specified
explicitly, default values for the partitioned table or
index would be used. If, in turn, default PCTUSED and/or
PCTFREE values for the partitioned table or index were not
specified, system defaults would be used.

Action: ensure that a sum of PCTUSED and PCTFREE for the
partition 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

PCC-02421: This host variable requires the use of an indicator variable

1 Answers  


TNS-00092: * CMANAGER (or intlsnr) - will ask the Cmanager only

1 Answers  


ORA-29886: feature not supported for domain indexes

1 Answers  


PCC-02398: Indicator ignored in this statement for this type

1 Answers  


ORA-36280: (XSCGMDLAGG08) The dimension of valueset workspace object is not in the dimension list of the current compiling model.

1 Answers  






ORA-06262: NETNTT: nfconn() failed

1 Answers  


LCD-00113: integer conversion error or negative integer [string]

1 Answers  


ORA-09881: sstasfre/sstasdel: shmdt error, unable to detach tas read page

1 Answers  


NNL-00537: set|show server [<server_name>] : set|show the currently managed server

1 Answers  


ORA-30084: invalid data type for datetime primary with time zone modifier

1 Answers  


DRG-11214: execution of procedure filter stored procedure has failed

1 Answers  


ORA-25461: rule set not specified

1 Answers  


Categories