Replication Management API Reference, 54 of 179

ADD_MASTER_DATABASE procedure

This procedure adds another master site to your replicated environment. This procedure regenerates all the triggers and their associated packages at existing master sites. You must call this procedure from the master definition site.

Syntax

DBMS_REPCAT.ADD_MASTER_DATABASE (
   gname                 IN   VARCHAR2,
   master                IN   VARCHAR2, 
   use_existing_objects  IN   BOOLEAN  := TRUE, 
   copy_rows             IN   BOOLEAN  := TRUE,
   comment               IN   VARCHAR2 := '',
   propagation_mode      IN   VARCHAR2 := 'ASYNCHRONOUS',
   fname                 IN   VARCHAR2 := NULL);

Parameters

Table 8-84 ADD_MASTER_DATABASE Procedure Parameters

Parameter	Description
gname	Name of the object group being replicated. This object group must already exist at the master definition site.
master	Fully qualified database name of the new master database.
use_existing_objects	Indicate `TRUE` if you want to reuse any objects of the same type and shape that already exist in the schema at the new master site. See Chapter 2, "Master Concepts & Architecture" in Oracle8i Replication for more information on how these changes are applied.
copy_rows	Indicate `TRUE` if you want the initial contents of a table at the new master site to match the contents of the table at the master definition site.
comment	This is added to the `MASTER_COMMENT` field of the `DBA_REPSITES` view.
propagation_mode	Method of forwarding changes to and receiving changes from new master database. Accepted values are `SYNCHRONOUS` and `ASYNCHRONOUS`.
fname	This parameter is for internal use only. Do not set this parameter unless directed to do so by Oracle Worldwide Support.

Exceptions

Table 8-85 ADD_MASTER_DATABASE Procedure Exceptions

Exception	Description
nonmasterdef	Invocation site is not the master definition site.
notquiesced	Replicated master group has not been suspended.
missingrepgroup	Object group does not exist at the specified database site.
commfailure	New master is not accessible.
typefailure	An incorrect propagation mode was specified.
notcompat	Compatibility mode must be 7.3.0.0 or greater.
duplrepgrp	Master site already exists.