Replication Management API Reference, 95 of 179

GENERATE_REPLICATION_SUPPORT procedure

This procedure generates the triggers and packages needed to support replication. You must call this procedure from the master definition site.

Syntax

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_objs_owner            IN    VARCHAR2   := NULL,
  min_communication         IN    BOOLEAN    := TRUE,
  generate_80_compatible    IN    BOOLEAN    := TRUE);

Parameters

Table 8-170 GENERATE_REPLICATION_SUPPORT Procedure Parameters

Parameter	Description
sname	Schema in which the object is located.
oname	Name of the object for which you are generating replication support.
type	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 `PACKAGE` or `PACKAGE` `BODY`, this value is prepended to the generated wrapper procedure names. By default, no prefix is assigned.
distributed	This must be set to `TRUE`.
gen_objs_owner	For objects of type `PACKAGE` or `PACKAGE BODY`, the schema in which the generated object should be created. If `NULL`, the objects are created in `SNAME`.
min_communication	Set to `FALSE` if any master site is running Oracle7 release 7.3. Set to `TRUE` when you want propagation of new and old values to be minimized. The default is `TRUE`. For more information, see Oracle8i Replication.
generate_80_ compatible	Set to `TRUE` if any master site is running a version of Oracle Server prior to Oracle8i release 8.1.5. Set to `FALSE` if replicated environment is a pure Oracle8i release 8.1.5 or greater environment.

Exceptions

Table 8-171 GENERATE_REPLICATION_SUPPORT Procedure Exceptions

Exception	Description
nonmasterdef	Invocation site is not the master definition site.
missingobject	Specified object does not exist as a table in the specified schema awaiting row-level replication information or as a package (body) awaiting wrapper generation.
typefailure	Specified type parameter is not supported.
notquiesced	Replicated master group has not been quiesced.
commfailure	At least one master site is not accessible.
missingschema	Schema does not exist.
dbnotcompatible	One of the masters is not 7.3.0.0 compatible.
notcompat	One of the masters is not 7.3.0.0 compatible. (Equivalent to `dbnotcompatible`.)
duplicateobject	Object already exists.