Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.GENERATE_REPLICATION_TRIGGER

Purpose

To generate the triggers and their associated packages needed to support replication for a given object at all master sites, or to generate the triggers and their associated packages needed to support replication for all of the objects in a given object group at a list of master sites. You must call this procedure from the master definition site. The associated object group must be quiesced. For additional information, refer to

Syntax

The parameters for the GENERATE_REPLICATION_TRIGGER procedure are described in Table 12 - 147, and the exceptions are listed in Table 12 - 148.

To generate support for an object at all master sites, use the syntax shown below:

DBMS_REPCAT.GENERATE_REPLICATION_TRIGGER(
                   sname             IN  VARCHAR2, 
                   oname             IN  VARCHAR2,
                   gen_rep2_trigger  IN  BOOLEAN := FALSE)

To generate support for an object group at selected master sites, use the syntax shown below:

DBMS_REPCAT.GENERATE_REPLICATION_TRIGGER(
                   gname         IN  VARCHAR2, 
                   master_list   IN  VARCHAR2 := NULL |
                   master_table  IN  dbms_utility.dblink_array)

Attention: If you want to generate support for a list of master sites (that is, if you will not be using the default, NULL), you must either use an array or named notation.

Parameter Description
sname The schema in which the object is located.
oname The name of the object for which you are generating replication support.
gen_rep2_trigger This parameter is provided for compatibility with previous releases. If you have any pre-release 7.3 snapshot sites, you must set this parameter to TRUE.
gname The name of the object group for which you want to generate support.
master_list A comma-separated list of master sites at which you want to generate replication support. By default, support is generated at all master sites.
master_table A PL/SQL table of master sites at which you want to generate replication support.

Table 12 - 147. Parameters for GENERATE_REPLICATION_TRIGGER

Exception Description
nonmasterdef The invocation site is not the master definition site.
missingobject The given object does not exist as a table in the given schema awaiting row-level replication information or as a procedure or package (body) awaiting wrapper generation.
notquiesced The replicated object group has not been suspended.
commfailure At least one master site is not accessible.
notcompat For pre-release 7.3 snapshot sites, you must set GEN_REP2_TRIGGER TRUE.

Table 12 - 148. Exceptions for GENERATE_REPLICATION_TRIGGER

Parameter	Description
`sname`	The schema in which the object is located.
`oname`	The name of the object for which you are generating replication support.
`gen_rep2_trigger`	This parameter is provided for compatibility with previous releases. If you have any pre-release 7.3 snapshot sites, you must set this parameter to TRUE.
`gname`	The name of the object group for which you want to generate support.
`master_list`	A comma-separated list of master sites at which you want to generate replication support. By default, support is generated at all master sites.
`master_table`	A PL/SQL table of master sites at which you want to generate replication support.

Exception	Description
nonmasterdef	The invocation site is not the master definition site.
missingobject	The given object does not exist as a table in the given schema awaiting row-level replication information or as a procedure or package (body) awaiting wrapper generation.
notquiesced	The replicated object group has not been suspended.
commfailure	At least one master site is not accessible.
notcompat	For pre-release 7.3 snapshot sites, you must set GEN_REP2_TRIGGER TRUE.