Skip Headers
Oracle® OLAP Reference
10g Release 2 (10.2)

Part Number B14350-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_OLAP2_CUBES

ALL_OLAP2_CUBES lists all cubes in an Oracle instance.

Column Data Type NULL Description
OWNER VARCHAR2(30) NOT NULL Owner of the cube that contains the measure.
CUBE_NAME VARCHAR2(30) NOT NULL Name of the cube that contains the measure.
INVALID VARCHAR2(2) NOT NULL Whether or not this cube is in an invalid state. See "Validating and Committing OLAP Catalog Metadata".
DISPLAY_NAME VARCHAR2(30)
Display name for the cube.
DESCRIPTION VARCHAR2(2000)
Description of the cube.
MV_SUMMARYCODE VARCHAR2(2)
If this cube has an associated materialized view, the MV summary code specifies whether it is in Grouping Set (groupingset) or Rolled Up (rollup) form.

See Chapter 27, "DBMS_ODM".