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-04091: table string.string is mutating, trigger/function may not see it

1 Answers  


EXP-00039: export file string must be on a disk

1 Answers  


NZE-29229: the magic number found in the header does not match expected

1 Answers  


IMG-00531: empty or null image processing command

1 Answers  


ORA-23371: column string unknown in table string

1 Answers  






TNS-00127: Missing Connection Manager name in TNSNET.ORA

1 Answers  


ORA-13117: [string]_RELATION$ table does not exist

1 Answers  


ORA-13135: failed to alter spatial table

1 Answers  


TNS-03602: Insufficient arguments. Usage: trcroute <address>

1 Answers  


ORA-14103: LOGGING/NOLOGGING may not be combined with RECOVERABLE/UNRECOVERABLE

1 Answers  


ORA-25426: remote instance does not support shared dblinks

1 Answers  


ORA-13866: Client identifier must be specified

1 Answers  


Categories