Oracle Distributed Systems

Name

DBMS_REPCAT.DO_DEFERRED_REPCAT_ADMIN

Synopsis

Whenever you create or alter replicated objects—for example, with the GENERATE_REPLICATION_SUPPORT or ALTER_MASTER_REPOBJECT procedure—Oracle queues the changes in the repcatlog queue; the entries in this queue correspond to entries in the DBA_REPCATLOG data dictionary view. All DDL changes must originate at the master definition site, but the repcatlog queue exists at every master site.

The DO_DEFERRED_REPCAT_ADMIN procedure performs administrative tasks queued in DBA_REPCAT for the specific replication group at the master site from which the call is made. If the all_sites parameter is set to TRUE, the tasks are applied at all masters. The specifications differ for Oracle7 and Oracle8 as follows.

Oracle7 specification:

PROCEDURE DBMS_REPCAT.DO_DEFERRED_REPCAT_ADMIN
   (gname IN VARCHAR2 := '',
    all_sites IN BOOLEAN := FALSE,
    sname IN VARCHAR2 := '');

Oracle8 specification:

PROCEDURE DBMS_REPCAT.DO_DEFERRED_REPCAT_ADMIN
   (gname IN VARCHAR2,
    all_sites IN BOOLEAN := FALSE);

Parameters

Parameter Name	Description
gname	Name of the replication group for which to push the repcatlog queue
all_sites	If TRUE, execute queued procedures at every master site
sname (Oracle7 only)	Schema name (provided for pre-Oracle 7.3 compatibility)

Exceptions

Exception Name	Number	Description
commfailure	–23317	Unable to communicate with master site.
nonmaster	–23312	Master site associated with snapshot group is no longer a master site.

Restrictions

The DO_DEFERRED_REPCAT_ADMIN procedure ...