ADD_MASTER_DATABASE Procedure

ADD_MAST ER_DATABASE Procedure

This procedure adds another master site to your replication env ironment. This procedure regenerates all the triggers and their associated packages at existing master sites. You must call this proc edure 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               I
N   VARCHAR2 := '',
   propagation_mode      IN   VARCHAR2 := 'ASYNCHRONOUS',
   fname
          IN   VARCHAR2 := NULL);

Parameters

Table 18-4 ADD_MASTER_DATABASE Procedure Parameters

Parameter	Description
gname	Name of the replica tion group being replicated. This replication 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.
< a name="94544">copy_rows	Indicate `true` if you wan t 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 comment is added to the `MASTER_COMMENT` field of the `DBA_REPS ITES` view.
propagation_mode	Method of forwarding changes to and receiving c hanges from new master database. Accepted values are `synchronous` and `asynchronous`.
fname	This parameter is for internal use only. Note: Do not set this parameter unless directed to do so by Oracle Support Services.

Exceptions

Table 18-5 ADD_MASTER_DATABASE Procedure E xceptions

Exception	Description
no nmasterdef	Invocation site is not the master definition site.
notquiesced	Replication has not been suspended for the master group.
missingrepgroup	Replication group does not exist at the specified database site.
commfailure	New master is not accessible.
typefailure	An incorrect propagation mode was specified.
duplrepgrp	Master sit e already exists.