DROP_ALL_TEMPLATE_SITES procedure

This procedure removes all entries from the DBA_REPCAT_TEMPLATE_SITES view, which keeps a record of sites that have instantiated a particular deployment template.

Caution: This is a dangerous procedure that cannot be undone. Additionally, Oracle8i Lite sites that have instantiated the dropped template will no longer be able to refresh their snapshots.

Syntax

DBMS_REPCAT_RGT.DROP_ALL_TEMPLATE_SITES (
   refresh_template_name   IN   VARCHAR2);

Parameters

Table 8-272 DROP_ALL_TEMPLATE_SITES Procedure Parameters

Parameter	Description
refresh_template_ name	Name of the deployment template that contains the sites that you want to drop.

Exceptions

Table 8-273 DROP_ALL_TEMPLATE_SITES Procedure Exceptions

Exception	Description
miss_refresh_ template	Specified deployment template name is invalid or does not exist.