O'Reilly logo

Oracle Distributed Systems by Charles Dye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required