Creating Fact Materialized Views With DBMS

CREATEDIMMV_GS Procedure

This procedure generates a script that creates a dimension table materialized view for each hierarchy of a dimension.

Syntax

CREATEDIMMV_GS (
               dimension_owner    IN   VARCHAR2,
               dimension_name     IN   VARCHAR2,
               output_file        IN   VARCHAR2,
               output_path        IN   VARCHAR2,
               tablespace_mv      IN   VARCHAR2 DEFAULT NULL,
               tablespace_index   IN   VARCHAR2 DEFAULT NULL);

Parameters

Table 30-5 CREATEDIMMV_GS Procedure Parameters

Parameter	Description
`dimension_owner`	Owner of the dimension.
`dimension_name`	Name of the dimension.
`output_file`	File name where the PL/SQL script will be written.
`output_path`	Directory path where `output_file` will be created.
`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.