Replication Management API Reference, 100 of 179

REFRESH_SNAPSHOT_REPGROUP procedure

This procedure refreshes a snapshot site object group with the most recent data from its associated master site.

Syntax

DBMS_REPCAT.REFRESH_SNAPSHOT_REPGROUP (
   gname                  IN   VARCHAR2,
   drop_missing_contents  IN   BOOLEAN    := FALSE,
   refresh_snapshots      IN   BOOLEAN    := FALSE,
   refresh_other_objects  IN   BOOLEAN    := FALSE
   gowner                 IN   VARCHAR2   := 'PUBLIC');

Parameters

Table 8-180 REFRESH_SNAPSHOT_REPGROUP Procedure Parameters

Parameter	Description
gname	Name of the replicated master group.
drop_missing_ contents	If an object was dropped from the replicated master group, then it is not automatically dropped from the schema at the snapshot site. It is simply no longer replicated. That is, changes to this object are no longer sent to its associated master site. Snapshots can continue to be refreshed from their associated master tables. However, any changes to an updatable snapshot are lost. When an object is dropped from the object group, you can choose to have it dropped from the schema entirely by setting this argument to `TRUE`.
refresh_snapshots	Set this to `TRUE` to refresh the contents of the snapshots in the replicated master group.
refresh_other_ objects	Set this to `TRUE` to refresh the contents of the non-snapshot objects in the replicated master group.
gowner	Owner of the snapshot group.

Exceptions

Table 8-181 REFRESH_SNAPSHOT_REPGROUP Procedure Exceptions

Exception	Description
nonsnapshot	Invocation site is not a snapshot site.
nonmaster	Master is no longer a master site.
commfailure	Master is not accessible.
missingrepgroup	Object group name not specified.