Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.DROP_SNAPSHOT_REPGROUP

Purpose

To drop a snapshot site from your replicated environment. For additional information, refer to

Syntax

The parameters for the DROP_SNAPSHOT_REPGROUP procedure are described in Table 12 - 135, and the exceptions are listed in Table 12 - 136. The syntax for this procedure is shown below:

DBMS_REPCAT.DROP_SNAPSHOT_REPGROUP(
			gname		IN	VARCHAR2, 
			drop_contents	IN	BOOLEAN := FALSE)

Parameter Description
gname The name of the replicated object 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 object group at a snapshot site, all of the objects remain in their associated schemas; they simply are no longer replicated. If you set this argument to TRUE, any replicated objects in the replicated object group are dropped from their schemas.

Table 12 - 135. Parameters for DROP_SNAPSHOT_REPSCHEMA

Exception Description
nonsnapshot The invocation site is not a snapshot site.
missrepgrp The specified object group does not exist.

Table 12 - 136. Exception for DROP_SNAPSHOT_REPSCHEMA

Parameter	Description
`gname`	The name of the replicated object 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 object group at a snapshot site, all of the objects remain in their associated schemas; they simply are no longer replicated. If you set this argument to TRUE, any replicated objects in the replicated object group are dropped from their schemas.

Exception	Description
nonsnapshot	The invocation site is not a snapshot site.
missrepgrp	The specified object group does not exist.