2.76 ALL_CLUSTERING_KEYS
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 |
See Also:
-
The
ALTER TABLE
section in Oracle Database SQL Language Reference for information about using theCLUSTERING
clause to create an attribute clustering table -
The
CREATE TABLE
section in Oracle Database SQL Language Reference for information about using theCLUSTERING
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