[Home] [Help]
[Dependency Information]
TABLE: SYS.HIERLEVEL$
Object Details
Object Name: | HIERLEVEL$ |
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Storage Details
Tablespace: | SYSTEM |
PCT Free: | 10 |
PCT Used: | 40 |
Indexes
Index |
Type |
Uniqueness |
Tablespace |
Column |
I_HIERLEVEL$_1
|
NORMAL
|
NONUNIQUE
|
SYSTEM
|
DIMOBJ#
HIERID#
|
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:
-
OLAPSYS
-
ALL$OLAP2UDIM_HIER_LEVEL_USES
-
ALL$OLAP2UDIM_LEVEL_ATTR_MAPS
-
ALL$OLAP2UJOIN_KEY_COLUMN_USES
-
ALL$OLAP2ULEVEL_KEY_COL_USES
-
ALL$OLAPMR_DIM_LEVELS
-
ALL$OLAPMR_DIM_LEVELS_KEYMAPS
-
ALL$OLAP_DIM_HIER_LEVEL_USES
-
ALL$OLAP_JOIN_KEY_COLUMN_USES
-
CWM2_OLAP_METADATA_REFRESH
- show dependent code
-
DBA$OLAP2UDIM_HIER_LEVEL_USES
-
DBA$OLAP2UDIM_LEVEL_ATTR_MAPS
-
DBA$OLAP2UJOIN_KEY_COLUMN_USES
-
DBA$OLAP2ULEVEL_KEY_COL_USES
-
DBA$OLAPMR_DIM_LEVELS_KEYMAPS
-
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
-
DBA_DIM_CHILD_OF