CREATEFACTMV_GS Procedure

This procedure generates a script that creates a fact table materialized view.

The materialized view will include all level combinations specified in the sys.olaptableveltuples table, which was created by the CREATECUBELEVELTUPLE Procedure.

Syntax

CREATEFACTMV_GS (
               cube_owner              IN   VARCHAR2,
               cube_name               IN   VARCHAR2,
               outfile                 IN   VARCHAR2,
               outfile_path            IN   VARCHAR2,
               partitioning            IN   BOOLEAN,
               tablespace_mv           IN   VARCHAR2 DEFAULT NULL,
               tablespace_index        IN   VARCHAR2 DEFAULT NULL);

Parameters

Table 30-4  CREATEFACTMV_GS Procedure Parameters

Parameter	Description
cube_owner	Owner of the cube.
cube_name	Name of the cube.
output_file	File name where the PL/SQL script will be written.
output_path	Directory path where output_file will be created.
partitioning	TRUE turns on index partitioning; FALSE turns it off.
tablespace_mv	The name of the tablespace in which the materialized view will be created. When this parameter is omitted, the materialized view is created in the user's default tablespace.
tablespace_index	The name of the tablespace in which the index for the materialized view will be created. When this parameter is omitted, the index is created in the user's default tablespace.