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 ... |
Get Oracle Distributed Systems now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.