VIEW: SYS.USER_CLUSTERING_JOINS

Source

View Text - Preformatted

select j.TABLE_NAME, j.TAB1_OWNER, j.TAB1_NAME,
       j.TAB1_COLUMN, j.TAB2_OWNER, j.TAB2_NAME,
       j.TAB2_COLUMN
from   DBA_CLUSTERING_JOINS j
WHERE  j.OWNER = SYS_CONTEXT('USERENV','CURRENT_USER')

View Text - HTML Formatted

SELECT J.TABLE_NAME
, J.TAB1_OWNER
, J.TAB1_NAME
, J.TAB1_COLUMN
, J.TAB2_OWNER
, J.TAB2_NAME
, J.TAB2_COLUMN FROM DBA_CLUSTERING_JOINS J WHERE J.OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER')