Replication Management API Reference, 91 of 179

DROP_SNAPSHOT_REPGROUP procedure

This procedure drops a snapshot site from your replicated environment. DROP_SNAPSHOT_REPGROUP automatically calls UNREGISTER_SNAPSHOT_REPGROUP to unregister the snapshot, but ignores any errors that may have occurred during unregistration.

Syntax

DBMS_REPCAT.DROP_SNAPSHOT_REPGROUP (
   gname                 IN   VARCHAR2, 
   drop_contents         IN   BOOLEAN   := FALSE
   gowner                IN   VARCHAR2  := 'PUBLIC');

Parameters

Table 8-161 DROP_SNAPSHOT_REPGROUP Procedure Parameters

Parameter	Description
gname	Name of the replicated master group that you want to drop from the current snapshot site. All objects generated to support replication, such as triggers and packages, are dropped.
drop_contents	By default, when you drop the replicated master group at a snapshot site, all of the objects remain in their associated schemas. They simply are no longer replicated. If you set this to `TRUE`, then any replicated objects in the replicated master group are dropped from their schemas.
gowner	Owner of the snapshot group.

Exceptions

Table 8-162 DROP_SNAPSHOT_REPGROUP Procedure Exceptions

Exception	Description
nonsnapshot	Invocation site is not a snapshot site.
missingrepgroup	Specified object group does not exist.