Oracle7 Server Distributed Systems Volume II: Replicated Data

Contents Index Home Previous Next

DBMS_REPCAT.DROP_MASTER_REPOBJECT

Purpose

To drop a replicated object from a replicated object group. You must call this procedure from the master definition site. For additional information, refer to [*].

Syntax

The parameters for the DROP_MASTER_REPOBJECT procedure are described in Table 12 - 123, and the exceptions are listed in Table 12 - 124. The syntax for this procedure is shown below:

DBMS_REPCAT.DROP_MASTER_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 remove from the replicated object group.
type The type of object that you want to drop.
drop_objects By default, the object remains in the schema, but is dropped from the replicated object group; that is, any changes to the object are no longer replicated to other master and snapshot sites. To completely remove the object from all master sites in the replicated environment, set this argument to TRUE.
Table 12 - 123. Parameters for DROP_MASTER_REPOBJECT

Exception Description
nonmasterdef The invocation site is not the master definition site.
missingobject The given object does not exist.
typefailure The given type parameter is not supported.
commfailure At least one master site is not accessible.
Table 12 - 124. Exceptions for DROP_MASTER_REPOBJECT

Contents Index Home Previous Next