VIEW: SYS.USER_CLUSTERING_TABLES

Source

View Text - Preformatted

select owner, table_name, clustering_type, on_load, on_datamovement, valid,
       with_zonemap, last_load_clst, last_datamove_clst
from   DBA_CLUSTERING_TABLES
WHERE  OWNER = SYS_CONTEXT('USERENV','CURRENT_USER')

View Text - HTML Formatted

SELECT OWNER
, TABLE_NAME
, CLUSTERING_TYPE
, ON_LOAD
, ON_DATAMOVEMENT
, VALID
, WITH_ZONEMAP
, LAST_LOAD_CLST
, LAST_DATAMOVE_CLST FROM DBA_CLUSTERING_TABLES WHERE OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER')