REFRESH_MVIEW_REPGROUP Procedure

This procedure refreshes a materialized view group with the most recent data from its associated master site or master materialized view site.

Syntax

DBMS_REPCAT.REFRESH_MVIEW_REPGROUP (
   gname                  IN   VARCHAR2,
   drop_missing_contents  IN   BOOLEAN    := false,
   refresh_mviews         IN   BOOLEAN    := false,
   refresh_other_objects  IN   BOOLEAN    := false,
   gowner                 IN   VARCHAR2   := 'PUBLIC');

Parameters

Table 18-108 REFRESH_MVIEW_REPGROUP Procedure Parameters

Parameter	Description
gname	Name of the replication group.
drop_missing_contents	If an object was dropped from the replication group at the master site or master materialized view site, then it is not automatically dropped from the schema at the materialized view site. It is simply no longer replicated. That is, changes to this object are no longer sent to its associated master site or master materialized view site. Materialized views can continue to be refreshed from their associated master tables or master materialized views. However, any changes to an updatable materialized view are lost. When an object is dropped from the replication group, you can choose to have it dropped from the schema entirely by setting this parameter to `true`.
refresh_mviews	Set to `true` to refresh the contents of the materialized views in the replication group.
refresh_other_objects	Set this to `true` to refresh the contents of the nonmaterialized view objects in the replication group. Nonmaterialized view objects may include the following: Tables Views Indexes PL/SQL packages and package bodies PL/SQL procedures and functions Triggers Synonyms
gowner	Owner of the materialized view group.

Exceptions

Table 18-109 REFRESH_MVIEW_REPGROUP Procedure Exceptions

Exception	Description
nonmview	Invocation site is not a materialized view site.
nonmaster	Master is no longer a master site or master materialized view site.
commfailure	Master site or master materialized view site is not accessible.
missingrepgroup	Replication group name not specified.