Database Error Messages

ORA-65419

columns in a clustering group come from different tables

Cause

Columns in the clustering group did not come from the same table. For example: .. CLUSTERING BY ..( (t1.c1, t2.c2), (t2.c1, t2.c2) ). Clustering group (t1.c1, t2.c2) must contain references to only one table.


Action

Restructure the clustering group so it contains only references to a single table.