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 ... |
Get Oracle Distributed Systems now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.