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
Wednesday, January 13, 2010
Get database clusters information
at 7:33 AM
Labels: DBA Tasks, Oracle, Oracle Query
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment