REMOVE_MASTER_DATABASES Procedure

This procedure removes one or more master databases from a replication 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.

Syntax

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

Note:

This procedure is overloaded. The master_list and master_table parameters are mutually exclusive.

Parameters

Table 18-116 REMOVE_MASTER_DATABASES Procedure Parameters

Parameter	Description
gname	Name of the replication group associated with the replication environment. This prevents confusion if a master database is involved in more than one replication environment.
master_list	A comma-delimited list of fully qualified master database names that you want to remove from the replication environment. There must be no spaces between names in the list.
master_table	In place of a list, you can specify the database names in a PL/SQL index-by table of type `DBMS_UTILITY`.`DBLINK_ARRAY`.

Exceptions

Table 18-117 REMOVE_MASTER_DATABASES Procedure Exceptions

Exception	Description
nonmasterdef	Invocation site is not the master definition site.
nonmaster	At least one of the specified databases is not a master site.
reconfigerror	One of the specified databases is the master definition site.
commfailure	At least one remaining master site is not accessible.