Oracle7 Server Distributed Systems Volume II: Replicated Data

Contents Index Home Previous Next

DBMS_REPCAT.REMOVE_MASTER_DATABASES

Purpose

To remove one or more master databases from a replicated environment. This procedure regenerates the triggers and their associated packages at the remaining master sites. You must call this procedure from the master definition site. For additional information, refer to [*].

Syntax

The parameters for the REMOVE_MASTER_DATABASES procedure are described in Table 12 - 161, and the exceptions are listed in Table 12 - 162. The syntax for this procedure is shown below:

DBMS_REPCAT.REMOVE_MASTER_DATABASES(
	gname	IN	VARCHAR2,
	master_list	IN	VARCHAR2 |
	master_table	IN	DBMS_UTILITY.DBLINK_ARRAY)

Parameter Description
gname The name of the object group associated with the replicated environment. This prevents confusion if a master database is involved in more than one replicated environment.
master_list A comma-separated list of fully qualified master database names that you want to remove from the replicated environment. There must be no extra whitespace between names in the list.
master_table In place of a list, you may also specify the database names in a PL/SQL table of type DBMS_UTILITY.DBLINK_ARRAY.
Table 12 - 161. Parameters for REMOVE_MASTER_DATABASES

Exception Description
nonmasterdef The invocation site is not the master definition site.
nonmaster At least one of the given databases is not a master site.
reconfigerror One of the given databases is the master definition site.
commfailure At least one remaining master site is not accessible.
Table 12 - 162. Exceptions for REMOVE_MASTER_DATABASES

Contents Index Home Previous Next