How to fix the Oracle error ORA-14161: subpartition number string: sum of PCTUSED and PCTFREE may not exceed 100?

In this post, you’ll learn more about the Oracle ErrorORA-14161: subpartition number string: sum of PCTUSED and PCTFREE may not exceed 100 with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-14161: subpartition number string: sum of PCTUSED and PCTFREE may not exceed 100

Reason for the Error ORA-14161: subpartition number string: sum of PCTUSED and PCTFREE may not exceed 100

the sum of PCTUSED and PCTFREE for a subpartition whose number (subpartitions are numbered starting with 1) is displayed in this message exceeds 100. Note that if PCTUSED and/or PCTFREE values for this subpartition were not specified explicitly, default values at partition-level would be used. If, in turn, default PCTUSED and/or PCTFREE values at partition-level were not specified, default values for the partitioned table or index would be used. If those values were also not specified explicitly, system defaults would be used.

How to fix the Error ORA-14161: subpartition number string: sum of PCTUSED and PCTFREE may not exceed 100 ?

You can fix this error in Oracle by following the below steps

ensure that a sum of PCTUSED and PCTFREE for the subpartition does not exceed 100