Name

DBMS_REPCAT.GENERATE_REPLICATION_PACKAGE

Synopsis

In some situations, you may wish to generate only replication support packages. GENERATE_REPLICATION_PACKAGE generates the table_name$RP package for the specified object at all master sites. The package is required for all tables participating in low-level replication.

PROCEDURE DBMS_REPCAT.GENERATE_REPLICATION__PACKAGE
   (sname IN VARCHAR2,
    oname IN VARCHAR2);

Parameters

Parameter Name

Description

sname

Name of the schema to which table oname belongs

oname

Name of table for which package is being generated

Exceptions

Exception Name

Number

Description

commfailure

–23317

Unable to communicate with all masters.

dbnotcompatible

–23375

One or more masters is a pre-7.3 release.

missingobject

–23308

Table oname does not exist in schema sname.

nonmasterdef

–23312

Calling site is not a master definition site.

notquiesced

–23310

Replication group to which object belongs is not quiesced.

Restrictions

  • You must call this procedure from the master definition site.

  • The replication group must be quiesced.

  • The Oracle version must be 7.3 or later.

Get Oracle Distributed Systems now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial