Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.DROP_SNAPSHOT_REPOBJECT

Purpose

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

Syntax

The parameters for the DROP_SNAPSHOT_REPOBJECT procedure are described in Table 12 - 137, and the exceptions are listed in Table 12 - 138. The syntax for this procedure is shown below:

DBMS_REPCAT.DROP_SNAPSHOT_REPOBJECT(	
			sname		IN	VARCHAR2,	
			oname		IN	VARCHAR2, 
			type		IN	VARCHAR2, 
			drop_objects	IN	BOOLEAN := FALSE)

Parameter Description
sname The name of the schema in which the object is located.
oname The name of the object that you want to drop from the replicated object group.
type The type of the object that you want to drop.
drop_objects By default, the object remains in its associated schema, but is dropped from its associated object group. To completely remove the object from its schema at the current snapshot site, set this argument to TRUE.

Table 12 - 137. Parameters for DROP_SNAPSHOT_REPOBJECT

Exception Description
nonsnapshot The invocation site is not a snapshot site.
missingobject The given object does not exist.
typefailure The given type parameter is not supported.

Table 12 - 138. Exceptions for DROP_SNAPSHOT_REPOBJECT

Parameter	Description
`sname`	The name of the schema in which the object is located.
`oname`	The name of the object that you want to drop from the replicated object group.
`type`	The type of the object that you want to drop.
`drop_objects`	By default, the object remains in its associated schema, but is dropped from its associated object group. To completely remove the object from its schema at the current snapshot site, set this argument to TRUE.

Exception	Description
nonsnapshot	The invocation site is not a snapshot site.
missingobject	The given object does not exist.
typefailure	The given type parameter is not supported.