Oracle Distributed Systems

Name

DBMS_REPCAT.RESUME_MASTER_ACTIVITY

Synopsis

The RESUME_MASTER_ACTIVITY procedure starts up an environment that has been or is in the process of being quiesced. The specifications differ for Oracle7 and Oracle8 as follows.

Oracle7 specification:

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

Oracle8 specification:

PROCEDURE DBMS_REPCAT.RESUME_MASTER_ACTIVITY
   (gname IN VARCHAR2,
    override IN BOOLEAN := FALSE);

Parameters

Parameter Name	Description
gname	Name of the replication group for which replication activity is to be resumed.
override	If FALSE (the default), activity is resumed only after all deferred REPCAT activity is completed; if set to TRUE, activity is resumed as soon as possible.
sname (Oracle7 only)	Schema name (provided for pre-Oracle 7.3 compatibility).

Exceptions

Exception Name	Number	Description
commfailure	–23317	Unable to communicate with one or more master sites.
nonmasterdef	–23312	Calling site is not the master definition site.
notquiesced	–23310	Replication group gname is not quiesced.

Restrictions

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

• The replication group must be quiesced or quiescing.