Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT

Purpose

To generate the triggers, packages, and procedures needed to support replication. You must call this procedure from the master definition site. For additional information, refer to

Syntax

The parameters for the GENERATE_REPLICATION_SUPPORT procedure are described in Table 12 - 145, and the exceptions are listed in Table 12 - 146. The syntax for this procedure is shown below:

DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT(
		sname 			IN 	VARCHAR2, 
		oname 			IN 	VARCHAR2, 
		type 			IN 	VARCHAR2, 
		package_prefix		IN 	VARCHAR2 := NULL, 
		procedure_prefix 	IN 	VARCHAR2 := NULL, 
		distributed 		IN 	BOOLEAN := TRUE,
		gen_rep2_trigger	IN	BOOLEAN := FALSE
		gen_obj_owner		IN	VARCHAR2 := '')

Parameter Description
sname The schema in which the object is located.
oname The name of the object for which you are generating replication support.
type The type of the object. The types supported are: TABLE, PACKAGE, and PACKAGE BODY.
package_prefix For objects of type PACKAGE or PACKAGE BODY this value is prepended to the generated wrapper package name. The default is DEFER_.
procedure_prefix For objects of type PROCEDURE, PACKAGE or PACKAGE BODY, this value is prepended to the generated wrapper procedure names. By default, no prefix is assigned. The default is DEFER_.
distributed This parameter must be set to TRUE if your COMPATIBLE parameter is set to 7.3.0 or greater.
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.
gen_obj_owner The name of the user you want to as as owner of the transaction.

Table 12 - 145. Parameters for 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.
typefailure The given type parameter is not supported.
notquiesced The replicated object group has not been suspended.
commfailure At least one master site is not accessible.

Table 12 - 146. Exceptions for GENERATE_REPLICATION_SUPPORT

Parameter	Description
`sname`	The schema in which the object is located.
`oname`	The name of the object for which you are generating replication support.
`type`	The type of the object. The types supported are: TABLE, PACKAGE, and PACKAGE BODY.
`package_prefix`	For objects of type PACKAGE or PACKAGE BODY this value is prepended to the generated wrapper package name. The default is DEFER_.
`procedure_prefix`	For objects of type PROCEDURE, PACKAGE or PACKAGE BODY, this value is prepended to the generated wrapper procedure names. By default, no prefix is assigned. The default is DEFER_.
`distributed`	This parameter must be set to TRUE if your COMPATIBLE parameter is set to 7.3.0 or greater.
`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.
gen_obj_owner	The name of the user you want to as as owner of the transaction.

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.
typefailure	The given type parameter is not supported.
notquiesced	The replicated object group has not been suspended.
commfailure	At least one master site is not accessible.