Wednesday, January 13, 2010

Get database clusters information

SELECT t1.OWNER,
TABLESPACE_NAME,
t1.CLUSTER_NAME,
TABLE_NAME,
TAB_COLUMN_NAME,
CLU_COLUMN_NAME
FROM dba_clusters t1, dba_clu_columns t2
WHERE t1.CLUSTER_NAME = t2.CLUSTER_NAME
ORDER BY t1.OWNER, TABLESPACE_NAME, t1.CLUSTER_NAME, TABLE_NAME

No comments:

Post a Comment

Oracle Query