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