[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')