 |
|
DBA_CLU_COLUMNS view tips
Oracle Tips by Burleson Consulting |
DBA_CLU_COLUMNS
<< Return to the index
Oracle 11g makes the following comments about the DBA_CLU_COLUMNS table: "Mapping of table columns to cluster columns"
Related notes on DBA_CLU_COLUMNS:
Column description of the DBA_CLU_COLUMNS view:OWNERDescription of DBA_CLU_COLUMNS.OWNER: "Owner of the cluster" CLUSTER_NAMEDescription of DBA_CLU_COLUMNS.CLUSTER_NAME: "Cluster name" CLU_COLUMN_NAMEDescription of DBA_CLU_COLUMNS.CLU_COLUMN_NAME: "Key column in the cluster" TABLE_NAMEDescription of DBA_CLU_COLUMNS.TABLE_NAME: "Clustered table name" TAB_COLUMN_NAMEDescription of DBA_CLU_COLUMNS.TAB_COLUMN_NAME: "Key column or attribute of object column in the table"
DBA_CLU_COLUMNS View SourceOracle 11g's data dictionary defines the DBA_CLU_COLUMNS view using the following source query:
select u.name, oc.name, cc.name, ot.name,
decode(bitand(tc.property, 1), 1, ac.name, tc.name)
from sys.user$ u, sys.obj$ oc, sys.col$ cc, sys.obj$ ot, sys.col$ tc,
sys.tab$ t, sys.attrcol$ ac
where oc.owner# = u.user#
and oc.obj# = cc.obj#
and t.bobj# = oc.obj#
and t.obj# = tc.obj#
and tc.segcol# = cc.segcol#
and t.obj# = ot.obj#
and oc.type# = 3
and tc.obj# = ac.obj#(+)
and tc.intcol# = ac.intcol#(+)
 |
If you like Oracle tuning, see the book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts. |
 |
 |
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
