Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.ALTER_MASTER_PROPAGATION

Purpose

To alter the propagation method for a given object group at a given master site. This object group must be quiesced. You must call this procedure from the master definition site. If the master appears in the dblink_list or dblink_table, ALTER_MASTER_PROPAGATION ignores that database link. There is no way to change the propagation mode from a master to itself. For additional information, refer to

Syntax

The parameters for the ALTER_MASTER_PROPAGATION procedure are described in Table 12 - 72, and the exceptions are listed in Table 12 - 73. The syntax for this procedure is shown below:

DBMS_REPCAT.ALTER_MASTER_PROPAGATION(
           gname             IN  VARCHAR2, 
           master            IN  VARCHAR2,
           dblink_list       IN  VARCHAR2, |
           dblink_table      IN  dbms_utility.dblink_array,
           propagation_mode  IN  VARCHAR2,
           comment           IN  VARCHAR2 := '')

Parameter Description
gname The name of the object group that you want to alter.
master The name of the master site at which to alter the object group.
dblink_list A comma-separated list of database links for which to alter propagation. If null, all masters except the master site being altered will be used by default.
dblink_table A PL/SQL table, indexed from position 1, of database links for which to alter propagation.
propagation_mode Determines the manner in which changes from the given master site are propagated to the sites identified by the list of database links. Appropriate values are SYNCHRONOUS and ASYNCHRONOUS.
comment This comment is added to the RepProp view.

Table 12 - 72. Parameters for ALTER_MASTER_PROPAGATION

Exception Description
nonmasterdef The local site is not the master definition site.
notquiesced The local site is not quiesced.
typefailure The propagation mode specified was not recognized.
nonmaster The list of database links includes a site that is not a master site.

Table 12 - 73. Exceptions for ALTER_MASTER_PROPAGATION

Parameter	Description
`gname`	The name of the object group that you want to alter.
`master`	The name of the master site at which to alter the object group.
`dblink_list`	A comma-separated list of database links for which to alter propagation. If null, all masters except the master site being altered will be used by default.
`dblink_table`	A PL/SQL table, indexed from position 1, of database links for which to alter propagation.
`propagation_mode`	Determines the manner in which changes from the given master site are propagated to the sites identified by the list of database links. Appropriate values are SYNCHRONOUS and ASYNCHRONOUS.
`comment`	This comment is added to the RepProp view.

Exception	Description
nonmasterdef	The local site is not the master definition site.
notquiesced	The local site is not quiesced.
typefailure	The propagation mode specified was not recognized.
nonmaster	The list of database links includes a site that is not a master site.