2.77 ALL_CLUSTERING_TABLES
ALL_CLUSTERING_TABLES
describes tables with an attribute clustering clause that are accessible to the user.
Related Views
-
DBA_CLUSTERING_TABLES
describes all the tables with an attribute clustering clause. -
USER_CLUSTERING_TABLES
describes the tables with an attribute clustering clause owned by the user.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the table |
|
|
|
Name of the table |
|
|
|
Clustering type:
|
|
|
|
Indicates whether Oracle will cluster data on load ( |
|
|
|
Indicates whether Oracle will cluster data on data movement, for example, partition move ( |
|
|
|
Indicates if clustering is valid ( For clustering with dimension tables, it is required that the joins of the fact table to the dimensions is via primary key or unique key on the dimension table. Therefore, dimension join keys must have a valid primary key or unique key constraint. If the primary key or unique key constraint is not valid, then clustering will not occur. If there are no joins in the |
|
|
|
Indicates if a zonemap was created with clustering ( |
|
|
|
Last time the clustering occurred on load |
|
|
|
Last time the clustering occurred on data movement, for example, partition move |
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