GENERATE_MVIEW_SUPPORT Procedure

This procedure activates triggers and generate packages needed to support the replication of updatable materialized views or procedural replication.You must call this procedure from the materialized view site.

Note:

CREATE_MVIEW_REPOBJECT automatically generates materialized view support for updatable materialized views.

Syntax

DBMS_REPCAT.GENERATE_MVIEW_SUPPORT (
   sname                    IN VARCHAR2,
   oname                    IN VARCHAR2,
   type                     IN VARCHAR2,
   gen_objs_owner           IN VARCHAR2 := '',
   min_communication        IN BOOLEAN  := true,
   generate_80_compatible   IN BOOLEAN  := true);

Parameters

Table 18-96 GENERATE_MVIEW_SUPPORT Procedure Parameters

Parameter	Description
sname	Schema in which the object is located.
oname	The name of the object for which you are generating support.
type	Type of the object. The types supported are `MATERIALIZED VIEW`, `PACKAGE`, and `PACKAGE BODY`.
gen_objs_owner	For objects of type `PACKAGE` or `PACKAGE BODY`, the schema in which the generated object should be created. If `NULL`, the objects are created in `SNAME`.
min_communication	If `true`, then the update trigger sends the new value of a column only if the update statement modifies the column. The update trigger sends the old value of the column only if it is a key column or a column in a modified column group.
generate_80_compatible	Set to `true` if the materialized view's master site is running a version of Oracle server prior to Oracle release 8.1.5. Set to `false` if the materialized view's master site or master materialized view site is running Oracle release 8.1.5 or higher.

Exceptions

Table 18-97 GENERATE_MVIEW_SUPPORT Procedure Exceptions

Exceptions	Descriptions
nonmview	Invocation site is not a materialized view site.
missingobject	Specified object does not exist as a materialized view in the replicated schema waiting for row/column-level replication information or as a package (body) waiting for wrapper generation.
typefailure	Specified type parameter is not supported.
missingschema	Specified owner of generated objects does not exist.
missingremoteobject	Object at master site or master materialized view site has not yet generated replication support.
commfailure	Master site or master materialized view site is not accessible.