Wednesday 14 March 2012

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

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 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 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

No comments:

Post a Comment