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

ORA-31416: invalid SOURCE_COLMAP value

1 Answers  


NNL-00960: Time until cache flush: string

1 Answers  


ORA-00316: log string of thread string, type string in header is not log file

1 Answers  


NZE-29239: the cryptographic engine could not initialize the algorithm

1 Answers  


ORA-13034: Invalid data in the SDO_ORDINATE_ARRAY in SDO_GEOMETRY object

1 Answers  






SQL*Loader-00941: Error during describe of table string

1 Answers  


ORA-08436: raw data has invalid sign digit

1 Answers  


RMAN-06600: old RMAN configuration parameters:

1 Answers  


QSM-01617: equivalence definition is disabled

1 Answers  


PLS-00414: no column 'string' in table

1 Answers  


ORA-16737: The log transport service for standby "string" has an error.

1 Answers  


LPX-00012: Unicode data alignment error

1 Answers  


Categories