Name
DBMS_REPCAT.ALTER_MASTER_PROPAGATION
Synopsis
The ALTER_MASTER_PROPAGATION procedure changes the propagation mode between specified master sites (from synchronous to asynchronous, or vice versa).
PROCEDURE DBMS_REPCAT.ALTER_MASTER_PROPAGATION
(gname IN VARCHAR2,
master IN VARCHAR2,
{dblink_table IN dbms_utility.dblink_array | dblink_list IN VARCHAR2},
propagation_modee IN VARCHAR2 := 'ASYNCHRONOUS',
comment IN VARCHAR2 := '');ALTER_MASTER_PROPAGATION does not automatically generate replication support triggers. After altering the propagation method, you must call GENERATE_REPLICATION_TRIGGER for replicated table in the replication group.
Parameters
Parameter Name | Description |
|---|---|
gname | Name of the replication group whose propagation mode is being altered |
master | Global name of the master site having its propagation mode altered |
dblink_list | List of database links for which the master’s propagation mode is being altered |
propagation_mode | New propagation mode (SYNCHRONOUS or ASYNCHRONOUS) |
comment | Comment visible in DBA_REPPROP data dictionary view |
Exceptions
Exception Name | Number | Description |
|---|---|---|
nonmaster | –23312 | One of the sites in dblink_list is not a master site. |
nonmasterdef | –23312 | Calling site is not the master definition site. |
notquiesced | –23310 | Replication group gname is not quiesced. |
typefailure | –23319 | The propagation_mode is not SYNCHRONOUS or ASYNCHRONOUS. |
Restrictions
You must run this procedure from the master definition site.
The replication group must be quiesced.