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