GENERATE_REPLICATION_SUPPORT Procedure

This procedure generates the triggers and packages needed to support replication for a specified object. 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 18-98 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	This parameter is obsolete. Use the default value (`true`).
generate_80_compatible	Set to `true` if any master site is running a version of Oracle server prior to Oracle release 8.1.5. Set to `false` if all master sites are running Oracle release 8.1.5 or higher.

Exceptions

Table 18-99 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 waiting for row-level replication information or as a package (body) waiting for wrapper generation.
typefailure	Specified type parameter is not supported.
notquiesced	Replication group has not been quiesced.
commfailure	At least one master site is not accessible.
missingschema	Schema does not exist.
duplicateobject	Object already exists.