Skip Headers

Oracle® Database Advanced Replication Management API Reference
10g Release 1 (10.1)

Part Number B10733-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to current chapter
Up
Go to next page
Next
View PDF

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.