[Home] [Help]
[Dependency Information]
TABLE: SYS.OLAP_HIERARCHIES$
Object Details
Object Name: | OLAP_HIERARCHIES$ |
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_HIERARCHIES$
|
NORMAL
|
UNIQUE
|
SYSTEM
|
DIM_OBJ#
HIERARCHY_ID
|
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
DIM_OBJ# |
NUMBER |
|
Yes |
|
HIERARCHY_NAME |
VARCHAR2 |
(128) |
Yes |
|
HIERARCHY_TYPE |
NUMBER |
|
Yes |
|
HIERARCHY_ID |
NUMBER |
|
Yes |
|
HIERARCHY_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#
, HIERARCHY_NAME
, HIERARCHY_TYPE
, HIERARCHY_ID
, HIERARCHY_ORDER
, SPARE2
, SPARE3
, SPARE4
, SPARE1
FROM SYS.OLAP_HIERARCHIES$;
Dependencies
[top of page]
SYS.OLAP_HIERARCHIES$ does not reference any database object
SYS.OLAP_HIERARCHIES$ is referenced by following:
-
SYS
-
ALL_CUBES
-
ALL_CUBE_ATTR_MAPPINGS
-
ALL_CUBE_ATTR_VISIBILITY
-
ALL_CUBE_CLASSIFICATIONS
-
ALL_CUBE_DEPENDENCIES
-
ALL_CUBE_DESCRIPTIONS
-
ALL_CUBE_DIMENSIONS
-
ALL_CUBE_DIMNL_MAPPINGS
-
ALL_CUBE_DIM_MAPPINGS
-
ALL_CUBE_HIERARCHIES
-
ALL_CUBE_HIER_LEVELS
-
ALL_CUBE_HIER_VIEWS
-
ALL_CUBE_HIER_VIEW_COLUMNS
-
ALL_CUBE_SUB_PARTITION_LEVELS
-
ALL_CUBE_VIEW_COLUMNS
-
DBA_CUBES
-
DBA_CUBE_ATTR_MAPPINGS
-
DBA_CUBE_ATTR_VISIBILITY
-
DBA_CUBE_CLASSIFICATIONS
-
DBA_CUBE_DEPENDENCIES
-
DBA_CUBE_DESCRIPTIONS
-
DBA_CUBE_DIMENSIONS
-
DBA_CUBE_DIMNL_MAPPINGS
-
DBA_CUBE_DIM_MAPPINGS
-
DBA_CUBE_HIERARCHIES
-
DBA_CUBE_HIER_LEVELS
-
DBA_CUBE_HIER_VIEWS
-
DBA_CUBE_HIER_VIEW_COLUMNS
-
DBA_CUBE_SUB_PARTITION_LEVELS
-
DBA_CUBE_VIEW_COLUMNS
-
DBMS_CUBE_ADVISE_SEC
- show dependent code
-
USER_CUBES
-
USER_CUBE_ATTR_MAPPINGS
-
USER_CUBE_ATTR_VISIBILITY
-
USER_CUBE_CLASSIFICATIONS
-
USER_CUBE_DEPENDENCIES
-
USER_CUBE_DESCRIPTIONS
-
USER_CUBE_DIMENSIONS
-
USER_CUBE_DIMNL_MAPPINGS
-
USER_CUBE_DIM_MAPPINGS
-
USER_CUBE_HIERARCHIES
-
USER_CUBE_HIER_LEVELS
-
USER_CUBE_HIER_VIEWS
-
USER_CUBE_HIER_VIEW_COLUMNS
-
USER_CUBE_SUB_PARTITION_LEVELS
-
USER_CUBE_VIEW_COLUMNS