DROP_SITE_INSTANTIATION procedure

This procedure drops a template instantiation at any target site, including RepAPI sites. This procedure removes all related metadata at the master site and disables the specified site from refreshing its snapshots.

Syntax

DBMS_REPCAT_RGT.DROP_SITE_INSTANTIATION (
     refresh_template_name  IN   VARCHAR2,
     user_name              IN   VARCHAR2,
     {site_name             IN   VARCHAR2,
     | repapi_site_id       IN   NUMBER   := -1e-130,}
     process_repapi_site    IN   VARCHAR2 := 'N');

Note: This procedure is overloaded. The site_name and repapi_site_id parameters are mutually exclusive.

Table 8-280 DROP_SITE_INSTANTIATION Procedure Parameters

Parameter	Description
refresh_template_name	The name of the deployment template to be dropped.
user_name	The name of the user who originally instantiated the template at the remote snapshot site. Query the ALL_REPCAT_TEMPLATE_SITES view to see the users that instantiated templates. See the "ALL_REPCAT_TEMPLATE_SITES" section for more information.
site_name	Identifies the Oracle server site where you want to drop the specified template instantiation. If you specify a SITE_NAME, do not specify a REPAPI_SITE_ID.
repapi_site_id	Identifies the RepAPI location where you want to drop the specified template instantiation. If you specify a REPAPI_SITE_ID, do not specify a SITE_NAME.
process_repapi_site	If set to 'Y' then the SITE_NAME is assumed to be a RepAPI SITE_NAME. The default value is 'N'. This parameter has no relevance if REPAPI_SITE_ID is non-NULL.

Exceptions

Table 8-281 DROP_SITE_INSTANTIATION Procedure Exceptions

Exception	Description
miss_refresh_ template	The deployment template name specified is invalid or does not exist.
miss_user	The username specified does not exist.
miss_template_site	The deployment template has not been instantiated for user and site.