How to fix the Oracle error ORA-04000: the sum of PCTUSED and PCTFREE cannot exceed 100?

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

Oracle Error Description

ORA-04000: the sum of PCTUSED and PCTFREE cannot exceed 100

Reason for the Error ORA-04000: the sum of PCTUSED and PCTFREE cannot exceed 100

the sum of PCTUSED and PCTFREE for a cluster or table exceeds 100

How to fix the Error ORA-04000: the sum of PCTUSED and PCTFREE cannot exceed 100 ?

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

create the table/cluster specifying values whose sum is <= 100