How to resolve ORA-04000 Error Message in Oracle database

Learn the purpose and how to unravel the ORA-04000 error message in Oracle.

Description

When you encounter an ORA-04000 error, the following error message will appear:

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

Cause

You tried to create a cluster or table the place the PCTUSED and PCTFREE added together passed 100

Resolution

The option(s) to resolve this Oracle error are:

Option #1

Try specifying values for PCTUSED and PCTFREE where these values delivered together do no longer exceed one hundred