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-30018: Create Rollback Segment failed, USN string is out of range

1 Answers  


ORA-26012: No data found while executing sql statement string for column string - check input for: string

1 Answers  


ORA-12912: Dictionary managed tablespace specified as temporary tablespace

1 Answers  


ORA-07258: spdcr: fork error, unable to create process.

1 Answers  


ORA-19004: Duplicate XMLType OBJECT RELATIONAL storage option

1 Answers  






RMAN-06424: error while looking up proxy copy

1 Answers  


NZE-29020: The handshake record length is too long.

1 Answers  


ORA-23379: connection qualifier "string" is too long

1 Answers  


ORA-38473: cannot drop a type used for Expression Filter attribute set

1 Answers  


PCC-02411: Invalid type for INDICATOR descriptor item host variable

1 Answers  


ORA-31192: Resource string has not been checked out

1 Answers  


ORA-07822: sspscm: SYS$CREMBX failure

1 Answers  


Categories