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-24015: cannot create QUEUE_TABLE, QUEUE_PAYLOAD_TYPE string.string does not exist

1 Answers  


TNS-04071: Connections closed successfully. Number closed: number.

1 Answers  


TNS-00508: No such protocol adapter

1 Answers  


SQL-02138: No external procedure context exists

1 Answers  


ORA-19678: RMAN configuration value exceeds maximum length of string

1 Answers  






ORA-24022: the specified parameters has no effect on the queue

1 Answers  


ORA-24131: table string has incorrect columns

1 Answers  


ORA-13911: Threshold not found

1 Answers  


ORA-31454: invalid value string for operation parameter, expecting: ADD or DROP

1 Answers  


ORA-01295: DB_ID mismatch between dictionary string and logfiles

1 Answers  


ORA-37035: (XSMLTDCL01) You can only DEFINE SESSION objects in analytic workspace string because it is attached in MULTI mode.

1 Answers  


ORA-22909: exceeded maximum VARRAY limit

1 Answers  


Categories