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


VIEW: OLAPSYS.ALL$OLAP2_AW_CATALOG_MEASURES

Object Details
Object Name: ALL$OLAP2_AW_CATALOG_MEASURES
Object Type: VIEW
Owner: OLAPSYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
AW_OWNER VARCHAR2 (30)
AW_NAME VARCHAR2 (30)
CATALOG_ID NUMBER

CATALOG_NAME VARCHAR2 (4000)
ENTITY_OWNER VARCHAR2 (4000)
ENTITY_NAME VARCHAR2 (4000)
CHILD_ENTITY_NAME VARCHAR2 (4000)
Query Text

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


SELECT AW_OWNER
,      AW_NAME
,      CATALOG_ID
,      CATALOG_NAME
,      ENTITY_OWNER
,      ENTITY_NAME
,      CHILD_ENTITY_NAME
FROM OLAPSYS.ALL$OLAP2_AW_CATALOG_MEASURES;

Dependencies

[top of page]

OLAPSYS.ALL$OLAP2_AW_CATALOG_MEASURES references the following:

SchemaOLAPSYS
TYPEALL_OLAP2_AW_METADATA_T
SchemaPUBLIC
SynonymOLAP_TABLE
OLAPSYS.ALL$OLAP2_AW_CATALOG_MEASURES is referenced by following:

SchemaPUBLIC
SynonymALL_OLAP2_AW_CATALOG_MEASURES