Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-65404

a table or materialized view can only have one CLUSTERING clause, remove the redundant clause(s)

Cause

The CLUSTERING clause was specified multiple times for the table or the materialized view yet a table or materialized view can only be clustered by a single order.


Action

Determine by which CLUSTERING clause you would like to cluster the table or the materialized view. Remove the other CLUSTERING clauses from the statement and re-execute the statement.