Replication Management API Reference, 148 of 179

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.