Skip Headers

Oracle9i OLAP User's Guide
Release 2 (9.2.0.2)

Part Number A95295-02
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 Go to next page
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.

CUBE_NAME

VARCHAR2(30)

NOT NULL

Name of the cube.

INVALID

VARCHAR2(2)

NOT NULL

Whether or not this cube is in an invalid state. See "Validating OLAP 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 10, "Creating Materialized Views for the OLAP API".