GENERATE_MVIEW_SCRIPT Procedure

Generates a simple script containing the SQL commands to implement Summary Advisor recommendations.

Syntax

DBMS_OLAP.GENERATE_MVIEW_SCRIPT(
filename     IN VARCHAR2,
id           IN NUMBER,
tspace        IN VARCHAR2);

Table 34-8 GENERATE_MVIEW_SCRIPT Procedure Parameters

Parameter	Datatype	Description
filename	VARCHAR2	Fully qualified output file name to receive HTML data. Note that the Oracle server restricts file access within Oracle stored procedures. See the "Security and Performance" section of the Java Developer's Guide for more information on file permissions
id	NUMBER	An ID that identifies an advisor run. The parameter DBMS_OLAP.RUNID_ALL indicates all advisor runs should be reported.
tspace	VARCHAR2	Optional tablespace name to use when creating materialized views.