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 the OWNER
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 |
Note:
This view is available starting with Oracle Database 12c Release 1 (12.1.0.2).
See Also:
The ALTER TABLE
section in Oracle Database SQL Language Reference for information about using the CLUSTERING
clause to create an attribute clustering table
The CREATE TABLE
section in Oracle Database SQL Language Reference for information about using the CLUSTERING
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