DBA Data[Home] [Help]

VIEW: SYS.USER_CLUSTERING_DIMENSIONS

Source

View Text - Preformatted

select d.TABLE_NAME, d.DIMENSION_OWNER, d.DIMENSION_NAME
from   DBA_CLUSTERING_DIMENSIONS d
WHERE  d.OWNER = SYS_CONTEXT('USERENV','CURRENT_USER')
View Text - HTML Formatted

SELECT D.TABLE_NAME
, D.DIMENSION_OWNER
, D.DIMENSION_NAME FROM DBA_CLUSTERING_DIMENSIONS D WHERE D.OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER')