ALL_CLUSTERING_KEYS

ALL_CLUSTERING_KEYS describes clustering keys for tables with an attribute clustering clause accessible to the user.

Related Views

  • DBA_CLUSTERING_KEYS describes clustering keys for all tables with an attribute clustering clause.

  • USER_CLUSTERING_KEYS describes clustering keys for tables with an attribute clustering clause owned by the user.


Column Datatype NULL Description

OWNER

VARCHAR2(128)

NOT NULL

Owner of the table on which the clustering clause is defined

TABLE_NAME

VARCHAR2(128)

NOT NULL

Name of the table on which the clustering clause is defined

DETAIL_OWNER

VARCHAR2(128)

NOT NULL

Owner of the detailed table contributing to the clustering keys

DETAIL_NAME

VARCHAR2(128)

NOT NULL

Name of the detailed table contributing to the clustering keys

DETAIL_COLUMN

VARCHAR2(128)

NOT NULL

Name of the detail column

POSITION

NUMBER

NOT NULL

Position of the column in the clustering clause

GROUPID

NUMBER

NOT NULL

Group ID of the column in the clustering clause


Note:

This view is available starting with Oracle Database 12c Release 1 (12.1.0.2).

See Also: