partition number string: sum of PCTUSED and PCTFREE may not exceed 100

Solution ID:ORA-14056

Type: Oracle

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.

Actions

Ensure that ALTER statement specifies new values only for attributes which may be changed once an object has been created

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm


https://community.oracle.com/message/3229900


Browse all solutions to database errors from Oracle, MS SQL, or MySQL