DROP_SITE_INSTANTIATION Procedure

This procedure drops a template instantiation at any target site. This procedure removes all related metadata at the master site and disables the specified site from refreshing its materialized views.

Syntax

DBMS_REPCAT_RGT.DROP_SITE_INSTANTIATION (
     refresh_template_name  IN   VARCHAR2,
     user_name              IN   VARCHAR2,
     site_name              IN   VARCHAR2);

Parameters

Table 21-50 DROP_SITE_INSTANTIATION Procedure Parameters

Parameter	Description
refresh_template_name	The name of the template that contains the site to be dropped.
user_name	The name of the user who originally instantiated the template at the remote materialized view site. Query the `ALL_REPCAT_TEMPLATE_SITES` view to see the users that instantiated templates. See the `ALL_REPCAT_TEMPLATE_SITES` view for more information.
site_name	Identifies the template site to be dropped.

Exceptions

Table 21-51 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.