Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E41527-09
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_CLUSTERING_TABLES

ALL_CLUSTERING_TABLES describes tables with an attribute clustering clause that are accessible to the user.

Related Views

Column Datatype NULL Description
OWNER VARCHAR2(128) NOT NULL Owner of the table
TABLE_NAME VARCHAR2(128) NOT NULL Name of the table
CLUSTERING_TYPE VARCHAR2(11)   Clustering type:
  • INTERLEAVED

  • LINEAR

ON_LOAD VARCHAR2(3)   Indicates whether Oracle will cluster data on load (YES) or not (NO)
ON_DATAMOVEMENT VARCHAR2(3)   Indicates whether Oracle will cluster data on data movement, for example, partition move (YES), or not (NO)
VALID VARCHAR2(3)   Indicates if clustering is valid (YES) or not (NO).

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 CLUSTERING clause, then the value of this column is YES.

WITH_ZONEMAP VARCHAR2(3)   Indicates if a zonemap was created with clustering (YES) or not (NO).
LAST_LOAD_CLST TIMESTAMP(6)   Last time the clustering occurred on load
LAST_DATAMOVE_CLST TIMESTAMP(6)   Last time the clustering occurred on data movement, for example, partition move

Note:

This view is available starting with Oracle Database 12c Release 1 (12.1.0.2).

See Also: