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 the OWNER column.


Column Datatype NULL Description

OWNER

VARCHAR2(128)

NOT NULL

Owner of the attribute clustering table

TABLE_NAME

VARCHAR2(128)

NOT NULL

Name of the attribute clustering table

TAB1_OWNER

VARCHAR2(128)

NOT NULL

Table 1 owner of the join

TAB1_NAME

VARCHAR2(128)

NOT NULL

Table 1 name of the join

TAB1_COLUMN

VARCHAR2(128)

NOT NULL

Table 1 column name of the join

TAB2_OWNER

VARCHAR2(128)

NOT NULL

Table 2 owner of the join

TAB2_NAME

VARCHAR2(128)

NOT NULL

Table 2 name of the join

TAB2_COLUMN

VARCHAR2(128)

NOT NULL

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: