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

TABLE: SYS.HIERLEVEL$

Object Details
Object Name: HIERLEVEL$
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_HIERLEVEL$_1 NORMAL NONUNIQUE TablespaceSYSTEM ColumnDIMOBJ#
ColumnHIERID#
Columns
Name Datatype Length Mandatory Comments
DIMOBJ# NUMBER
Yes
HIERID# NUMBER
Yes
POS# NUMBER
Yes
LEVELID# NUMBER
Yes
JOINKEYID# NUMBER

SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 VARCHAR2 (1000)
SPARE4 DATE

Query Text

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


SELECT DIMOBJ#
,      HIERID#
,      POS#
,      LEVELID#
,      JOINKEYID#
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
FROM SYS.HIERLEVEL$;

Dependencies

[top of page]

SYS.HIERLEVEL$ does not reference any database object

SYS.HIERLEVEL$ is referenced by following:

SchemaSYS
ViewDBA_DIM_CHILD_OF