VIEW: SYS.ALL_CLUSTERING_DIMENSIONS

Source

View Text - Preformatted

select d.OWNER, d.TABLE_NAME, d.DIMENSION_OWNER, d.DIMENSION_NAME
from   DBA_CLUSTERING_DIMENSIONS d, ALL_TABLES t
WHERE  d.OWNER = t.OWNER
AND    d.TABLE_NAME = t.TABLE_NAME

View Text - HTML Formatted

SELECT D.OWNER
, D.TABLE_NAME
, D.DIMENSION_OWNER
, D.DIMENSION_NAME FROM DBA_CLUSTERING_DIMENSIONS D
, ALL_TABLES T WHERE D.OWNER = T.OWNER AND D.TABLE_NAME = T.TABLE_NAME