VIEW: SYS.ALL_CLUSTERING_JOINS

Source

View Text - Preformatted

select j.OWNER, 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, ALL_TABLES t
WHERE  j.OWNER = t.OWNER
AND    j.TABLE_NAME = t.TABLE_NAME

View Text - HTML Formatted

SELECT J.OWNER
, 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
, ALL_TABLES T WHERE J.OWNER = T.OWNER AND J.TABLE_NAME = T.TABLE_NAME