DBA Data[Home] [Help] [Dependency Information]


TABLE: SYS.CLSTKEY$

Object Details
Object Name: CLSTKEY$
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
I_CLSTKEY$ NORMAL NONUNIQUE TablespaceSYSTEM ColumnCLSTOBJ#
Columns
Name Datatype Length Mandatory Comments
CLSTOBJ# NUMBER
Yes
TABOBJ# NUMBER
Yes
INTCOL# NUMBER
Yes
POSITION NUMBER
Yes
GROUPID NUMBER
Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CLSTOBJ#
,      TABOBJ#
,      INTCOL#
,      POSITION
,      GROUPID
FROM SYS.CLSTKEY$;

Dependencies

[top of page]

SYS.CLSTKEY$ does not reference any database object

SYS.CLSTKEY$ is referenced by following:

SchemaSYS
ViewDBA_CLUSTERING_KEYS
ProcedureDBMS_FEATURE_PARTITION_SYSTEM - show dependent code
ProcedureDBMS_FEATURE_PARTITION_USER - show dependent code
ProcedureDBMS_FEATURE_ZMAP - show dependent code
ViewKU$_CLSTCOL_VIEW