Oracle Distributed Systems

Name

DBMS_REPCAT.REFRESH_SNAPSHOT_REPGROUP

Synopsis

The REFRESH_SNAPSHOT_REPGROUP procedure refreshes the snapshot replication group manually. Specifications differ for Oracle7 and Oracle8 as follows.

Oracle7 specification:

PROCEDURE 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,
    execute_as_user IN BOOLEAN:= FALSE);

Oracle8 specification:

PROCEDURE DBMS_REPCAT.REFRESH_SNAPSHOT_REPGROUP
   (gname IN VARCHAR2,
    drop_missing_contents IN BOOLEAN := FALSE,
    refresh_other_objects IN BOOLEAN := FALSE )

The procedure can optionally drop objects that are no longer in the group and/or refresh the snapshots and other objects.

The REFRESH_SNAPSHOT_REPGROUP procedure replaces the REFRESH_SNAPSHOT_REPSCHEMA procedure. Although REFRESH_SNAPSHOT_REPSCHEMA still exists (as of Oracle 7.3.3), do not use it; it does not exist in Oracle 8.0.3.

Parameters

Parameter Name	Description
gname	Name of the replication group.
drop_missing_contents	If TRUE, drop schema objects that are no longer in the snapshot group. If FALSE (the default), objects are simply no longer replicated.
refresh_snapshots	If TRUE, force a refresh of snapshots in gname. Default is FALSE.
refresh_other_objects	If TRUE, refresh nonsnapshot objects in gname, such as views and procedures. Nonsnapshot objects are refreshed by dropping and re-creating them. Default is FALSE.
execute_as_user (Oracle7 only)	FALSE (default) indicates ...