ALL_CLUSTERING_KEYS
describes clustering keys for tables with an attribute clustering clause accessible to the user.
Related Views
DBA_CLUSTERING_KEYS
describes clustering keys for all tables with an attribute clustering clause.
USER_CLUSTERING_KEYS
describes clustering keys for tables with an attribute clustering clause owned by the user.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the table on which the clustering clause is defined |
|
|
|
Name of the table on which the clustering clause is defined |
|
|
|
Owner of the detailed table contributing to the clustering keys |
|
|
|
Name of the detailed table contributing to the clustering keys |
|
|
|
Name of the detail column |
|
|
|
Position of the column in the clustering clause |
|
|
|
Group ID of the column in the clustering clause |
Note:
This view is available starting with Oracle Database 12c Release 1 (12.1.0.2).
See Also:
The ALTER TABLE
section in Oracle Database SQL Language Reference for information about using the CLUSTERING
clause to create an attribute clustering table
The CREATE TABLE
section in Oracle Database SQL Language Reference for information about using the CLUSTERING
clause to create an attribute clustering table
Oracle Database Data Warehousing Guide for information about dimension tables
Oracle Database Data Warehousing Guide for information about attribute clustering with zone maps