[Home] [Help]
[Dependency Information]
TABLE: SYS.DIMLEVEL$
Object Details
Object Name: | DIMLEVEL$ |
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_DIMLEVEL$_1
|
NORMAL
|
UNIQUE
|
SYSTEM
|
DIMOBJ#
LEVELID#
|
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
DIMOBJ# |
NUMBER |
|
Yes |
|
LEVELID# |
NUMBER |
|
Yes |
|
LEVELNAME |
VARCHAR2 |
(128) |
|
|
SPARE1 |
NUMBER |
|
|
|
SPARE2 |
NUMBER |
|
|
|
SPARE3 |
VARCHAR2 |
(1000) |
|
|
SPARE4 |
DATE |
|
|
|
FLAGS |
NUMBER |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT DIMOBJ#
, LEVELID#
, LEVELNAME
, SPARE1
, SPARE2
, SPARE3
, SPARE4
, FLAGS
FROM SYS.DIMLEVEL$;
Dependencies
[top of page]
SYS.DIMLEVEL$ does not reference any database object
SYS.DIMLEVEL$ is referenced by following:
-
OLAPSYS
-
ALL$OLAP2UDIM_HIER_LEVEL_USES
-
ALL$OLAP2UDIM_LEVELS
-
ALL$OLAP2UDIM_LEVEL_ATTRIBUTES
-
ALL$OLAP2UDIM_LEVEL_ATTR_MAPS
-
ALL$OLAP2UJOIN_KEY_COLUMN_USES
-
ALL$OLAP2ULEVEL_KEY_COL_USES
-
ALL$OLAP2ULISTDIMS
-
ALL$OLAPMR_ATTRIBUTES
-
ALL$OLAPMR_DIM_LEVELS
-
ALL$OLAPMR_DIM_LEVELS_KEYMAPS
-
ALL$OLAP_DIM_ATTR_USES
-
ALL$OLAP_DIM_HIER_LEVEL_USES
-
ALL$OLAP_DIM_LEVELS
-
ALL$OLAP_DIM_LEVEL_ATTRIBUTES
-
ALL$OLAP_DIM_LEVEL_ATTR_MAPS
-
ALL$OLAP_JOIN_KEY_COLUMN_USES
-
ALL$OLAP_LEVEL_KEY_COLUMN_USES
-
CWM$EXPORT
- show dependent code
-
CWM$OLAP$CUBE
- show dependent code
-
CWM$OLAP$DIM$ATTRIBUTE
- show dependent code
-
CWM$OLAP$LEVEL
- show dependent code
-
CWM$OLAP$LEVEL$ATTRIBUTE
- show dependent code
-
CWM$UTIL
- show dependent code
-
CWM$UTILITY
- show dependent code
-
CWM2_OLAP_METADATA_REFRESH
- show dependent code
-
DBA$OLAP2UDIM_HIER_LEVEL_USES
-
DBA$OLAP2UDIM_LEVELS
-
DBA$OLAP2UDIM_LEVEL_ATTRIBUTES
-
DBA$OLAP2UDIM_LEVEL_ATTR_MAPS
-
DBA$OLAP2UJOIN_KEY_COLUMN_USES
-
DBA$OLAP2ULEVEL_KEY_COL_USES
-
DBA$OLAP2ULISTDIMS
-
DBA$OLAPMR_DIM_LEVELS_KEYMAPS
-
DBA$OLAP_DIM_ATTR_USES
-
DBA$OLAP_DIM_HIER_LEVEL_USES
-
DBA$OLAP_DIM_LEVELS
-
DBA$OLAP_DIM_LEVEL_ATTRIBUTES
-
DBA$OLAP_DIM_LEVEL_ATTR_MAPS
-
DBA$OLAP_JOIN_KEY_COLUMN_USES
-
DBA$OLAP_LEVEL_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_ATTRIBUTES
-
ALL_DIM_LEVELS
-
ALL_DIM_LEVEL_KEY
-
DBA_DIM_ATTRIBUTES
-
DBA_DIM_CHILD_OF
-
DBA_DIM_JOIN_KEY
-
DBA_DIM_LEVELS
-
DBA_DIM_LEVEL_KEY
-
USER_DIM_ATTRIBUTES
-
USER_DIM_LEVELS
-
USER_DIM_LEVEL_KEY