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-29746: Cluster Synchronization Service is being shut down.

1 Answers  


PCC-02386: Use of the AT clause is not permitted here

1 Answers  


RMAN-12019: continuing other job steps, job failed will not be re-run

1 Answers  


ORA-25463: table alias not specified

1 Answers  


ORA-06920: CMX: getbrkmsg illegal datatype

1 Answers  






IMP-00044: unable to allocate enough memory for statement

1 Answers  


RMAN-06535: LIST COPY OF SPFILE is not supported

1 Answers  


ORA-01642: begin backup not needed for read only tablespace 'string'

1 Answers  


ORA-23488: propagation mode "string" for "string" is not allowed for this operation

1 Answers  


ORA-06791: TLI Driver: poll returned error event

1 Answers  


ORA-12571: TNS:packet writer failure

1 Answers  


ORA-21704: cannot terminate cache or connection without flushing first

1 Answers  


Categories