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-29536: badly formed source: string

1 Answers  


PCC-00121: Arrays of VARCHAR pointers are not supported

1 Answers  


PLS-00720: type 'string' has evolved

1 Answers  


LPX-00224: multiple occurrences of attribute "~S" found

1 Answers  


ORA-07229: slcpuc: error in getting number of CPUs.

1 Answers  






SQL*Loader-00522: lfiopn failed for file (string)

1 Answers  


ORA-31463: logfile location string is an empty directory

1 Answers  


LPX-00227: entity "~S" is not a parsed entity

1 Answers  


ORA-13407: invalid storage parameter

1 Answers  


ORA-40211: algorithm name string is invalid

1 Answers  


LSX-00215: value "~1S" whose total digits exceeds ~2d

1 Answers  


ORA-04020: deadlock detected while trying to lock object stringstringstringstringstring

1 Answers  


Categories