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

TABLE: SYS.OLAP_HIER_LEVELS$

Object Details
Object Name: OLAP_HIER_LEVELS$
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_OLAP_HIER_LEVELS$ NORMAL UNIQUE TablespaceSYSTEM ColumnHIERARCHY_ID
ColumnORDER_NUM
Columns
Name Datatype Length Mandatory Comments
HIERARCHY_ID NUMBER
Yes
ORDER_NUM NUMBER
Yes
HIERARCHY_LEVEL_ID NUMBER
Yes
DIM_LEVEL_ID NUMBER
Yes
SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 VARCHAR2 (1000)
SPARE4 VARCHAR2 (1000)
Query Text

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


SELECT HIERARCHY_ID
,      ORDER_NUM
,      HIERARCHY_LEVEL_ID
,      DIM_LEVEL_ID
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
FROM SYS.OLAP_HIER_LEVELS$;

Dependencies

[top of page]

SYS.OLAP_HIER_LEVELS$ does not reference any database object

SYS.OLAP_HIER_LEVELS$ is referenced by following:

SchemaSYS
ViewALL_CUBES
ViewALL_CUBE_ATTR_MAPPINGS
ViewALL_CUBE_ATTR_VISIBILITY
ViewALL_CUBE_CLASSIFICATIONS
ViewALL_CUBE_DEPENDENCIES
ViewALL_CUBE_DESCRIPTIONS
ViewALL_CUBE_DIMNL_MAPPINGS
ViewALL_CUBE_DIM_MAPPINGS
ViewALL_CUBE_HIER_LEVELS
ViewALL_CUBE_HIER_VIEW_COLUMNS
ViewALL_CUBE_SUB_PARTITION_LEVELS
ViewALL_CUBE_VIEW_COLUMNS
ViewDBA_CUBES
ViewDBA_CUBE_ATTR_MAPPINGS
ViewDBA_CUBE_ATTR_VISIBILITY
ViewDBA_CUBE_CLASSIFICATIONS
ViewDBA_CUBE_DEPENDENCIES
ViewDBA_CUBE_DESCRIPTIONS
ViewDBA_CUBE_DIMNL_MAPPINGS
ViewDBA_CUBE_DIM_MAPPINGS
ViewDBA_CUBE_HIER_LEVELS
ViewDBA_CUBE_HIER_VIEW_COLUMNS
ViewDBA_CUBE_SUB_PARTITION_LEVELS
ViewDBA_CUBE_VIEW_COLUMNS
ViewUSER_CUBES
ViewUSER_CUBE_ATTR_MAPPINGS
ViewUSER_CUBE_ATTR_VISIBILITY
ViewUSER_CUBE_CLASSIFICATIONS
ViewUSER_CUBE_DEPENDENCIES
ViewUSER_CUBE_DESCRIPTIONS
ViewUSER_CUBE_DIMNL_MAPPINGS
ViewUSER_CUBE_DIM_MAPPINGS
ViewUSER_CUBE_HIER_LEVELS
ViewUSER_CUBE_HIER_VIEW_COLUMNS
ViewUSER_CUBE_SUB_PARTITION_LEVELS
ViewUSER_CUBE_VIEW_COLUMNS