[Home] [Help] [Dependency Information]
Object Name: | ALL_CLUSTERING_TABLES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Description of the clustering clause of tables accessible to the user
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Yes | Owner of the table |
TABLE_NAME | VARCHAR2 | (128) | Yes | Name of the table |
CLUSTERING_TYPE | VARCHAR2 | (11) | Clustering type | |
ON_LOAD | VARCHAR2 | (3) | Will Oracle cluster data on load | |
ON_DATAMOVEMENT | VARCHAR2 | (3) | Will Oracle cluster data on data movement, for example partition move | |
VALID | VARCHAR2 | (3) | Is clustering valid. It is invalid if dimension does not have pk/uk constraint | |
WITH_ZONEMAP | VARCHAR2 | (3) | Is a zonemap also created with clustering | |
LAST_LOAD_CLST | TIMESTAMP(6) | (11) | Last time the clustering occured on load | |
LAST_DATAMOVE_CLST | TIMESTAMP(6) | (11) | Last time the clustering occured on data movement, for example partition move |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, TABLE_NAME
, CLUSTERING_TYPE
, ON_LOAD
, ON_DATAMOVEMENT
, VALID
, WITH_ZONEMAP
, LAST_LOAD_CLST
, LAST_DATAMOVE_CLST
FROM SYS.ALL_CLUSTERING_TABLES;
|
|
|