Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-01155: the database is being opened, closed, mounted or dismounted

1 Answers  


DRG-11866: Please Try `ftp://' Instead Of `file://'

1 Answers  


LPX-00231: invalid character ~1u ('~2c') found in a Name or Nmtoken

1 Answers  


ORA-01604: illegal number range in clause "string" of string

1 Answers  


ORA-08120: Need to create SYS.IND_ONLINE$ table in order to (re)build index

1 Answers  






PLS-00430: FORALL iteration variable string is not allowed in this context

1 Answers  


KUP-03014: OCI error getting datetime fsprecision.

1 Answers  


ORA-12600: TNS: string open failed

1 Answers  


KUP-03009: OCI error getting column name.

1 Answers  


ORA-10646: Too many recursive extensions during SYSTEM tablespace migration

1 Answers  


ORA-25191: cannot reference overflow table of an index-organized table

1 Answers  


TNS-00541: underlying transport does not exist.

1 Answers  






Categories