UNDO_ADD_NEW_MASTERS_REQUEST Procedure

This procedure undoes all of the changes ma de 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 e xisting master sites affected by the request. You can query the DBA_REPSITES_NEW data dictionary view to see the new mas ter sites affected by the extension_id. This data dictionary view also lists the replication group name, and you must ru n 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 procedur e 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_PROPAGATIO N_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 18-137 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 con tents.

Exceptions

< em>Table 18-138 UNDO_ADD_NEW_MASTERS_REQUEST Procedure Exceptions

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