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

TABLE: SYS.OLAP_MEASURES$

Object Details
Object Name: OLAP_MEASURES$
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_MEASURES_INDEX$ NORMAL UNIQUE TablespaceSYSTEM ColumnCUBE_OBJ#
ColumnMEASURE_ID
Columns
Name Datatype Length Mandatory Comments
CUBE_OBJ# NUMBER
Yes
MEASURE_NAME VARCHAR2 (128) Yes
MEASURE_ID NUMBER
Yes
MEASURE_TYPE NUMBER (2) Yes
TYPE# NUMBER
Yes
LENGTH NUMBER
Yes
CHARSETFORM NUMBER

PRECISION# NUMBER

SCALE NUMBER

IS_STALE NUMBER (1) Yes
IS_HIDDEN NUMBER (1)
MEASURE_ORDER NUMBER

SPARE2 NUMBER

SPARE3 VARCHAR2 (1000)
SPARE4 VARCHAR2 (1000)
TYPE_PROPERTY NUMBER

SPARE1 NUMBER

Query Text

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


SELECT CUBE_OBJ#
,      MEASURE_NAME
,      MEASURE_ID
,      MEASURE_TYPE
,      TYPE#
,      LENGTH
,      CHARSETFORM
,      PRECISION#
,      SCALE
,      IS_STALE
,      IS_HIDDEN
,      MEASURE_ORDER
,      SPARE2
,      SPARE3
,      SPARE4
,      TYPE_PROPERTY
,      SPARE1
FROM SYS.OLAP_MEASURES$;

Dependencies

[top of page]

SYS.OLAP_MEASURES$ does not reference any database object

SYS.OLAP_MEASURES$ is referenced by following:

SchemaSYS
ViewALL_CUBE_CLASSIFICATIONS
ViewALL_CUBE_DEPENDENCIES
ViewALL_CUBE_DESCRIPTIONS
ViewALL_CUBE_MEASURES
ViewALL_CUBE_MEAS_MAPPINGS
ViewALL_CUBE_VIEW_COLUMNS
ViewALL_MEASURE_FOLDER_CONTENTS
ViewALL_METADATA_PROPERTIES
ViewDBA_CUBE_CLASSIFICATIONS
ViewDBA_CUBE_DEPENDENCIES
ViewDBA_CUBE_DESCRIPTIONS
ViewDBA_CUBE_MEASURES
ViewDBA_CUBE_MEAS_MAPPINGS
ViewDBA_CUBE_VIEW_COLUMNS
ViewDBA_MEASURE_FOLDER_CONTENTS
ViewUSER_CUBE_CLASSIFICATIONS
ViewUSER_CUBE_DEPENDENCIES
ViewUSER_CUBE_DESCRIPTIONS
ViewUSER_CUBE_MEASURES
ViewUSER_CUBE_MEAS_MAPPINGS
ViewUSER_CUBE_VIEW_COLUMNS
ViewUSER_MEASURE_FOLDER_CONTENTS