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


VIEW: OLAPSYS.ALL$OLAP1_CUBES

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (240)
CUBE_NAME VARCHAR2 (240)
INVALID VARCHAR2 (4000)
DISPLAY_NAME VARCHAR2 (240)
SHORT_DESCRIPTION VARCHAR2 (4000)
DESCRIPTION VARCHAR2 (4000)
MV_SUMMARYCODE VARCHAR2 (2)
Query Text

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


SELECT OWNER
,      CUBE_NAME
,      INVALID
,      DISPLAY_NAME
,      SHORT_DESCRIPTION
,      DESCRIPTION
,      MV_SUMMARYCODE
FROM OLAPSYS.ALL$OLAP1_CUBES;

Dependencies

[top of page]

OLAPSYS.ALL$OLAP1_CUBES references the following:

SchemaOLAPSYS
TableCWM$CUBE
TableCWM$CUBEDIMENSIONUSE
TableCWM$DIMENSION
TableCWM$MODEL
PL/SQL PackageCWM$UTIL - show dependent code
SchemaPUBLIC
SynonymDBA_USERS
SynonymV$ENABLEDPRIVS
SchemaSYS
TableOBJ$
OLAPSYS.ALL$OLAP1_CUBES is referenced by following:

SchemaOLAPSYS
ViewALL$OLAP2UCUBES
ViewALL$OLAPMR_FACTTBLKEYMAPS
SchemaPUBLIC
SynonymALL_OLAP1_CUBES