[Home] [Help] [Dependency Information]

TABLE: SYS.HIER$

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
I_HIER$_1	NORMAL	UNIQUE	SYSTEM	DIMOBJ# HIERID#

Columns

Query Text

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

SELECT DIMOBJ#
,      HIERID#
,      HIERNAME
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
FROM SYS.HIER$;

Dependencies

[top of page]

SYS.HIER$ does not reference any database object

SYS.HIER$ is referenced by following:

OLAPSYS

ALL$OLAP2UDIM_HIERARCHIES

ALL$OLAP2UDIM_HIER_LEVEL_USES

ALL$OLAP2UDIM_LEVEL_ATTR_MAPS

ALL$OLAP2UHIER_CUSTOM_SORT

ALL$OLAP2UJOIN_KEY_COLUMN_USES

ALL$OLAP2ULEVEL_KEY_COL_USES

ALL$OLAP9I1_HIER_DIMENSIONS

ALL$OLAPMR_DIM_LEVELS

ALL$OLAPMR_DIM_LEVELS_KEYMAPS

ALL$OLAP_DIM_HIERARCHIES

ALL$OLAP_DIM_HIER_LEVEL_USES

ALL$OLAP_JOIN_KEY_COLUMN_USES

CWM$OLAP$HIERARCHY - show dependent code

CWM$UTIL - show dependent code

CWM$UTILITY - show dependent code

CWM2_OLAP_METADATA_REFRESH - show dependent code

CWM2_OLAP_TABLE_MAP - show dependent code

DBA$OLAP2UDIM_HIERARCHIES

DBA$OLAP2UDIM_HIER_LEVEL_USES

DBA$OLAP2UDIM_LEVEL_ATTR_MAPS

DBA$OLAP2UHIER_CUSTOM_SORT

DBA$OLAP2UJOIN_KEY_COLUMN_USES

DBA$OLAP2ULEVEL_KEY_COL_USES

DBA$OLAP9I1_HIER_DIMENSIONS

DBA$OLAPMR_DIM_LEVELS_KEYMAPS

DBA$OLAP_DIM_HIERARCHIES

DBA$OLAP_DIM_HIER_LEVEL_USES

DBA$OLAP_JOIN_KEY_COLUMN_USES

EXPORT2UDIM_HIER_LEVEL_USES

EXPORT2UJOIN_KEY_COLUMN_USES

ODM$OLAP2UDIM_HIER_LEVEL_USES

ODM$OLAP2UJOIN_KEY_COLUMN_USES

ODM$OLAP2ULEVEL_KEY_COL_USES

SYS

ALL_DIM_HIERARCHIES

DBA_DIM_CHILD_OF

DBA_DIM_HIERARCHIES

DBA_DIM_JOIN_KEY

USER_DIM_HIERARCHIES