DBMS_REPCAT, 66 of 69

UNDO_ADD_NEW_MASTERS_REQUEST Procedure

This procedure undoes all of the changes made by the SPECIFY_NEW_MASTERS and ADD_NEW_MASTERS procedures for a specified extension_id.

This procedure is executed at one master site, which may be the master definition site, and it only affects that master site. If you run this procedure at one master site affected by the request, you must run it at all new and existing master sites affected by the request. You can query the DBA_REPSITES_NEW data dictionary view to see the new master sites affected by the extension_id. This data dictionary view also lists the replication group name, and you must run this procedure at all existing master sites in the replication group.

Caution:

This procedure is not normally called. Use this procedure only if the adding new masters without quiesce operation cannot proceed at one or more master sites. Run this procedure after you have already run the SPECIFY_NEW_MASTERS and ADD_NEW_MASTERS procedures, but before you have run the RESUME_PROPAGATION_TO_MDEF and PREPARE_INSTANTIATED_MASTER procedures.

Do not run this procedure after you have run either RESUME_PROPAGATION_TO_MDEF or PREPARE_INSTANTIATED_MASTER for a particular extension_id.

See Also:

Syntax

DBMS_REPCAT.UNDO_ADD_NEW_MASTERS_REQUEST (
   extension_id         IN RAW,
   drop_contents        IN BOOLEAN := TRUE);

Parameters

Table 48-134 UNDO_ADD_NEW_MASTERS_REQUEST Procedure Parameters

Parameter	Description
extension_id	The identifier for the current pending request to add master databases to a master group without quiesce. You can find the `extension_id` by querying the `DBA_REPSITES_NEW` and `DBA_REPEXTENSIONS` data dictionary views.
drop_contents	Specify `true`, the default, to drop the contents of objects in new replication groups being extended at the local site. Specify `false` to retain the contents.

Exceptions

Table 48-135 UNDO_ADD_NEW_MASTERS_REQUEST Procedure Exceptions

Exception	Description
dbnotcompatible	Feature is incompatible with database version. All databases must be at 9.0.0 or higher compatibility level.
typefail	A parameter value that you specified is not appropriate.