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

TABLE: SYS.OLAP_DESCRIPTIONS$

Object Details
Object Name: OLAP_DESCRIPTIONS$
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_OLAP_DESCRIPTION$ NORMAL UNIQUE TablespaceSYSTEM ColumnOWNING_OBJECT_TYPE
ColumnOWNING_OBJECT_ID
ColumnLANGUAGE
ColumnDESCRIPTION_TYPE
Columns
Name Datatype Length Mandatory Comments
OBJ# NUMBER
Yes
OWNING_OBJECT_TYPE NUMBER
Yes
OWNING_OBJECT_ID NUMBER
Yes
LANGUAGE VARCHAR2 (80) Yes
DESCRIPTION_TYPE VARCHAR2 (128) Yes
DESCRIPTION_VALUE NVARCHAR2 (600)
DESCRIPTION_CLASS NUMBER

SPARE2 NUMBER

SPARE3 VARCHAR2 (1000)
SPARE4 VARCHAR2 (1000)
DESCRIPTION_ORDER NUMBER

SPARE1 NUMBER

Query Text

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


SELECT OBJ#
,      OWNING_OBJECT_TYPE
,      OWNING_OBJECT_ID
,      LANGUAGE
,      DESCRIPTION_TYPE
,      DESCRIPTION_VALUE
,      DESCRIPTION_CLASS
,      SPARE2
,      SPARE3
,      SPARE4
,      DESCRIPTION_ORDER
,      SPARE1
FROM SYS.OLAP_DESCRIPTIONS$;

Dependencies

[top of page]

SYS.OLAP_DESCRIPTIONS$ does not reference any database object

SYS.OLAP_DESCRIPTIONS$ is referenced by following:

SchemaSYS
ViewALL_CUBES
ViewALL_CUBE_ATTRIBUTES
ViewALL_CUBE_BUILD_PROCESSES
ViewALL_CUBE_CLASSIFICATIONS
ViewALL_CUBE_DESCRIPTIONS
ViewALL_CUBE_DIMENSIONS
ViewALL_CUBE_DIM_LEVELS
ViewALL_CUBE_DIM_MODELS
ViewALL_CUBE_HIERARCHIES
ViewALL_CUBE_HIER_LEVELS
ViewALL_CUBE_MEASURES
ViewALL_MEASURE_FOLDERS
ViewDBA_CUBES
ViewDBA_CUBE_ATTRIBUTES
ViewDBA_CUBE_BUILD_PROCESSES
ViewDBA_CUBE_CLASSIFICATIONS
ViewDBA_CUBE_DESCRIPTIONS
ViewDBA_CUBE_DIMENSIONS
ViewDBA_CUBE_DIM_LEVELS
ViewDBA_CUBE_DIM_MODELS
ViewDBA_CUBE_HIERARCHIES
ViewDBA_CUBE_HIER_LEVELS
ViewDBA_CUBE_MEASURES
ViewDBA_MEASURE_FOLDERS
ViewUSER_CUBES
ViewUSER_CUBE_ATTRIBUTES
ViewUSER_CUBE_BUILD_PROCESSES
ViewUSER_CUBE_CLASSIFICATIONS
ViewUSER_CUBE_DESCRIPTIONS
ViewUSER_CUBE_DIMENSIONS
ViewUSER_CUBE_DIM_LEVELS
ViewUSER_CUBE_DIM_MODELS
ViewUSER_CUBE_HIERARCHIES
ViewUSER_CUBE_HIER_LEVELS
ViewUSER_CUBE_MEASURES
ViewUSER_MEASURE_FOLDERS