VIEW: SYS.ALL_CLUSTERING_TABLES

Source

View Text - Preformatted

select c.owner, c.table_name, c.clustering_type, c.on_load, c.on_datamovement,
       c.valid, c.with_zonemap, c.last_load_clst, c.last_datamove_clst
from   DBA_CLUSTERING_TABLES c, ALL_TABLES t
WHERE  c.OWNER = t.OWNER
AND    c.TABLE_NAME = t.TABLE_NAME

View Text - HTML Formatted

SELECT C.OWNER
, C.TABLE_NAME
, C.CLUSTERING_TYPE
, C.ON_LOAD
, C.ON_DATAMOVEMENT
, C.VALID
, C.WITH_ZONEMAP
, C.LAST_LOAD_CLST
, C.LAST_DATAMOVE_CLST FROM DBA_CLUSTERING_TABLES C
, ALL_TABLES T WHERE C.OWNER = T.OWNER AND C.TABLE_NAME = T.TABLE_NAME