eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: ODM.ODM_CLUSTER

Object Details

Object Name:	ODM_CLUSTER
Object Type:	TABLE
Owner:	ODM
Subobject Name:
Status:	VALID

Primary Key: SYS_C00155380

Unique Key: SYS_C00155381

SYS_NC0001300014$

Unique Key: SYS_C00155382

SYS_NC0001100012$

Unique Key: SYS_C00155383

SYS_NC0000900010$

Unique Key: SYS_C00155384

SYS_NC0000700008$

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_C00155380	NORMAL	UNIQUE	ODM	ID
SYS_C00155381	NORMAL	UNIQUE	ODM	CHILD
SYS_C00155382	NORMAL	UNIQUE	ODM	HISTOGRAM
SYS_C00155383	NORMAL	UNIQUE	ODM	CENTROID
SYS_C00155384	NORMAL	UNIQUE	ODM	SPLIT_PREDICATE

Columns

Name	Datatype	Length	Mandatory
ID	NUMBER	(7)	Yes
RECORD_COUNT	NUMBER	(10)
TREE_LEVEL	NUMBER	(7)
PARENT	NUMBER	(7)
SPLIT_PREDICATE	PREDICATE_TAB_TYPE	(16)
CENTROID	CENTROID_TAB_TYPE	(16)
HISTOGRAM	ATTRIBUTE_HISTOGRAM_TAB_TYPE	(16)
CHILD	CHILD_TAB_TYPE	(16)

Query Text

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


SELECT ID
,      RECORD_COUNT
,      TREE_LEVEL
,      PARENT
,      SPLIT_PREDICATE
,      CENTROID
,      HISTOGRAM
,      CHILD
FROM ODM.ODM_CLUSTER;

Dependencies

[top of page]

ODM.ODM_CLUSTER references the following:

ODM: ATTRIBUTE_HISTOGRAM_TAB_TYPE; CENTROID_TAB_TYPE; CHILD_TAB_TYPE; CLUSTER_TYPE; PREDICATE_TAB_TYPE
SYS: STANDARD - show dependent code

ODM.ODM_CLUSTER is not referenced by any database object