Oracle Distributed Systems

Name

DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT

Synopsis

The GENERATE_REPLICATION_SUPPORT procedure generates support for replicated tables, packages, and package bodies required to support replication of the specified object, which can be a table, procedure, package, or package body. The typical use of GENERATE_REPLICATION_SUPPORT is to regenerate the replication support triggers and procedures after changing a replication group’s mode of propagation.

If the object is a table, GENERATE_REPLICATION_SUPPORT creates the table_name$RT triggers on the table, as well as the table_name$RP and table_name$RR packages at all master sites.

If the object is a procedure, package or package body, GENERATE_REPLICATION_SUPPORT generates the requisite procedure wrappers for it. The name of the wrapper procedure is in the format package_prefixoname for packages and package bodies, and procedure_prefixoname for procedures. If the parameters package_prefix or procedure_prefix are not supplied, the default prefix DEFER_ is used.

The specifications differ for Oracle7 and Oracle8 as follows.

Oracle7 specification:

PROCEDURE 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,
    gen_rep2_trigger  IN BOOLEAN  := FALSE);

Oracle8 specification:

PROCEDURE DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (sname IN VARCHAR2, oname IN VARCHAR2, type ...