[Home] [Help] [Dependency Information]

TABLE: SYS.DIM$

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
I_DIM$_1	NORMAL	UNIQUE	SYSTEM	OBJ#

Columns

Query Text

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

SELECT OBJ#
,      DIMTEXTLEN
,      DIMTEXT
,      FLAGS
,      NUMLEVELS
,      NUMLEVKEYS
,      NUMJOINKEYS
,      NUMHIER
,      NUMHIERLV
,      NUMATTR
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
FROM SYS.DIM$;

Dependencies

[top of page]

SYS.DIM$ does not reference any database object

SYS.DIM$ is referenced by following:

OLAPSYS

ALL$AW_CUBE_AGG_LEVELS

ALL$AW_LOAD_CUBE_AGG_LEVELS

ALL$AW_LOAD_CUBE_DIMS

ALL$AW_LOAD_DIM_MAP

ALL$OLAP2UDIM_LEVEL_ATTR_MAPS

ALL$OLAP2UHIER_CUSTOM_SORT

ALL$OLAP2ULEVEL_KEY_COL_USES

ALL$OLAP2ULISTDIMS

ALL$OLAP9I1_HIER_DIMENSIONS

ALL$OLAPMR_DIMENSIONS

ALL$OLAP_DIMENSIONS

CWM$OLAP$DIMENSION - show dependent code

CWM$OLAP$HIERARCHY - show dependent code

CWM$OLAP$LEVEL - show dependent code

CWM$UTILITY - show dependent code

CWM1_OLAP_VALIDATE_METADATA - show dependent code

CWM2_OLAP_METADATA_REFRESH - show dependent code

CWM2_OLAP_TABLE_MAP - show dependent code

CWM2_OLAP_VALIDATE - show dependent code

DBA$OLAP2UDIM_LEVEL_ATTR_MAPS

DBA$OLAP2UHIER_CUSTOM_SORT

DBA$OLAP2ULEVEL_KEY_COL_USES

DBA$OLAP2ULISTDIMS

DBA$OLAP9I1_HIER_DIMENSIONS

DBA$OLAPMR_DIMENSIONS

DBA$OLAP_DIMENSIONS

EXPORTOLAPMR_DIMENSIONS

MRV$OLAP1_POP_DIMENSIONS

ODM$OLAP2ULEVEL_KEY_COL_USES

SYS

ALL_DIMENSIONS

DBA_DIMENSIONS

EXU8DIM

KU$_DIMENSION_VIEW

USER_DIMENSIONS