Name
DBMS_REPCAT.ADD_MASTER_DATABASE
Synopsis
The ADD_MASTER_DATABASE procedure adds a master site to an existing replication group and initializes all objects at the new site. The specifications differ for Oracle7 and Oracle8 as follows.
Oracle7 specification:
PROCEDURE 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',
sname IN VARCHAR2 := '');Oracle8 specification:
PROCEDURE 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');It is generally easier to instantiate all objects at the new master site first. That way, the call to ADD_MASTER_DATABASE does not have to perform DDL to create the schema or send all of the data across a network link. If you instantiate the objects first, the call to ADD_MASTER_DATABASE only has to generate replication support for the objects and update other master sites with the new master’s existence.
Parameters
Parameter Name | Description |
|---|---|
gname | Name of the replication group to which master site is being added. |
master | Global name of the new master site. |
use_existing_objects | Reuse existing objects at the new site. |
copy_rows | Copy rows from the invoking site to the new master site. |
comment | Comment on new master site, visible in DBA_REPSITES ... |