ORA-14057: partition "string": sum of PCTUSED and PCTFREE
may not exceed 100



ORA-14057: partition "string": sum of PCTUSED and PCTFREE may not exceed 100..

Answer / guest

Cause: the sum of PCTUSED and PCTFREE for a partition whose
name (explicitly specified by the user) 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-16705: severe internal error in resource guard

1 Answers  


NNO-00115: line string: single-value data type "string", other instances ignored

1 Answers  


ORA-00292: parallel recovery feature not installed

1 Answers  


DRG-10709: this preference is referenced by string and cannot be dropped

1 Answers  


DRG-10510: stopword is missing

1 Answers  






SQL*Loader-00609: value used for ROWS parameter changed from number to number

1 Answers  


PLS-00147: LIBRARY file specification string is empty

1 Answers  


ORA-39065: unexpected master process exception in string

1 Answers  


ORA-28182: cannot acquire Kerberos service ticket for client

1 Answers  


PROT-00017: Fatal Error

1 Answers  


TNS-00122: Missing ADDRESS(es) in TNSNET.ORA file

1 Answers  


ORA-13157: Oracle error ORAstring encountered while string

1 Answers  


Categories