GENERATE_REPLICATION_SUPPORT Procedure

This procedure generates the triggers and pa ckages 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    VARC
HAR2   := NULL,
  min_communication         IN    BOOLEAN    := true,
  generate_80_compatibl
e    IN    BOOLEAN    := true);

Parameters

Table 18-98 GENERATE_REPLICATION_SUPPORT Procedure Parameters

< /tr>

Param eter	Description
sname	Schema in wh ich the object is located.
oname	Name of the object for which you are generating r eplication support.
type	Type of the object. The types supported are: `TABLE< /code>, PACKAGE, and PACKAGE BODY.`
package_prefix	For ob jects of type `PACKAGE` or `PACKAGE BODY` this value is prepended to the generated wrapper package name. The de fault 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 assign ed.`
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 serv er 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 GENE RATE_REPLICATION_SUPPORT Procedure Exceptions

Exception	< strong>Description
nonmasterdef	Invocation site is not the master definition site.
missingobject	Specified object does not exist as a ta ble in the specified schema waiting for row-level replication information or as a package (body) waiting for wrapper generation. < /td>
typefailure < /td>	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 .
duplicateobjec t	Object already exists.