[Home] [Help]
[Dependency Information]
TABLE: SYS.OLAP_DIM_LEVELS$
Object Details
Object Name: | OLAP_DIM_LEVELS$ |
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_OLAP_DIM_LEVELS$
|
NORMAL
|
UNIQUE
|
SYSTEM
|
LEVEL_ID
|
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
DIM_OBJ# |
NUMBER |
|
Yes |
|
LEVEL_NAME |
VARCHAR2 |
(128) |
Yes |
|
LEVEL_ID |
NUMBER |
|
Yes |
|
LEVEL_ORDER |
NUMBER |
|
|
|
SPARE2 |
NUMBER |
|
|
|
SPARE3 |
VARCHAR2 |
(1000) |
|
|
SPARE4 |
VARCHAR2 |
(1000) |
|
|
SPARE1 |
NUMBER |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT DIM_OBJ#
, LEVEL_NAME
, LEVEL_ID
, LEVEL_ORDER
, SPARE2
, SPARE3
, SPARE4
, SPARE1
FROM SYS.OLAP_DIM_LEVELS$;
Dependencies
[top of page]
SYS.OLAP_DIM_LEVELS$ does not reference any database object
SYS.OLAP_DIM_LEVELS$ is referenced by following:
-
SYS
-
ALL_CUBES
-
ALL_CUBE_ATTR_MAPPINGS
-
ALL_CUBE_ATTR_UNIQUE_KEYS
-
ALL_CUBE_ATTR_VISIBILITY
-
ALL_CUBE_CLASSIFICATIONS
-
ALL_CUBE_DEPENDENCIES
-
ALL_CUBE_DESCRIPTIONS
-
ALL_CUBE_DIMNL_MAPPINGS
-
ALL_CUBE_DIM_LEVELS
-
ALL_CUBE_DIM_MAPPINGS
-
ALL_CUBE_HIER_LEVELS
-
ALL_CUBE_HIER_VIEW_COLUMNS
-
ALL_CUBE_SUB_PARTITION_LEVELS
-
ALL_CUBE_VIEW_COLUMNS
-
DBA_CUBES
-
DBA_CUBE_ATTR_MAPPINGS
-
DBA_CUBE_ATTR_UNIQUE_KEYS
-
DBA_CUBE_ATTR_VISIBILITY
-
DBA_CUBE_CLASSIFICATIONS
-
DBA_CUBE_DEPENDENCIES
-
DBA_CUBE_DESCRIPTIONS
-
DBA_CUBE_DIMNL_MAPPINGS
-
DBA_CUBE_DIM_LEVELS
-
DBA_CUBE_DIM_MAPPINGS
-
DBA_CUBE_HIER_LEVELS
-
DBA_CUBE_HIER_VIEW_COLUMNS
-
DBA_CUBE_SUB_PARTITION_LEVELS
-
DBA_CUBE_VIEW_COLUMNS
-
USER_CUBES
-
USER_CUBE_ATTR_MAPPINGS
-
USER_CUBE_ATTR_UNIQUE_KEYS
-
USER_CUBE_ATTR_VISIBILITY
-
USER_CUBE_CLASSIFICATIONS
-
USER_CUBE_DEPENDENCIES
-
USER_CUBE_DESCRIPTIONS
-
USER_CUBE_DIMNL_MAPPINGS
-
USER_CUBE_DIM_LEVELS
-
USER_CUBE_DIM_MAPPINGS
-
USER_CUBE_HIER_LEVELS
-
USER_CUBE_HIER_VIEW_COLUMNS
-
USER_CUBE_SUB_PARTITION_LEVELS
-
USER_CUBE_VIEW_COLUMNS