DATABASE CLUSTER NOTES

 

Clusters

 DATABASE CLUSTER NOTES:

Owner - Owner of the table/cluster

Tablespace - Name of the tablespace containing the cluster

Cluster Name - Name of the cluster

Table Name - Clustered table name

Table Column - Key column in the table

Cluster Column - Key column in the cluster

select  a.OWNER,
 TABLESPACE_NAME,
 a.CLUSTER_NAME,
 TABLE_NAME,
 TAB_COLUMN_NAME,
 CLU_COLUMN_NAME
from  dba_clusters a, dba_clu_columns b
where a.CLUSTER_NAME = b.CLUSTER_NAME
order  by a.OWNER,TABLESPACE_NAME,a.CLUSTER_NAME,TABLE_NAME