You are here: Home // Oracle 11g // 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 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. See the solution below.

Error solution: ensure that a sum of PCTUSED and PCTFREE for the partition does not exceed 100

Database version: Oracle 11g Release 2 (11.2)

Tags: ,

Leave a Reply

Copyright © 2009 Oracle Error Codes Database. All rights reserved.
Powered by WordPress.
Promotes: praca lekarz Ubezpieczenie zdrowotne Restauracja Białystok zlecę remont mieszkania warszawa hotel borowiecki łódź