Oracle / PLSQL: ORA-04000 Error Message

Learn the cause and how to resolve 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 where the PCTUSED and PCTFREE added together exceeded 100.

Resolution

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

Option #1

Try specifying values for PCTUSED and PCTFREE where these values added together do not exceed 100.