2.77 ALL_CLUSTERING_JOINS
ALL_CLUSTERING_JOINS
describes joins to the dimension tables associated with tables with an attribute clustering clause the user owns or has system privileges for.
Related Views
-
DBA_CLUSTERING_JOINS
describes joins to the dimension tables associated with all tables with an attribute clustering clause in the database. -
USER_CLUSTERING_JOINS
describes joins to the dimension tables associated with tables with an attribute clustering clause owned by the user. This view does not display theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the attribute clustering table |
|
|
|
Name of the attribute clustering table |
|
|
|
Table 1 owner of the join |
|
|
|
Table 1 name of the join |
|
|
|
Table 1 column name of the join |
|
|
|
Table 2 owner of the join |
|
|
|
Table 2 name of the join |
|
|
|
Table 2 column name of the join |
See Also:
-
The
ALTER TABLE
section in Oracle Database SQL Language Reference for information about using theCLUSTERING
clause to create an attribute clustering table -
The
CREATE TABLE
section in Oracle Database SQL Language Reference for information about using theCLUSTERING
clause to create an attribute clustering table -
Oracle Database Data Warehousing Guide for information about dimension tables
-
Oracle Database Data Warehousing Guide for information about attribute clustering with zone maps