Replication Management API Reference, 149 of 179

DROP_TEMPLATE_OBJECT procedure

This procedure removes a template object from a specific deployment template. For example, a DBA would use this procedure to remove an outdated snapshot from a deployment template. Changes made to the template are reflected at new sites instantiating the deployment template. Remote sites that have already instantiated the template must reinstantiate the deployment template to apply the changes.

Syntax

DBMS_REPCAT_RGT.DROP_TEMPLATE_OBJECT (
   refresh_template_name  IN   VARCHAR2, 
   object_name            IN   VARCHAR2,
   object_type            IN   VARCHAR2);

Parameters

Table 8-282 DROP_TEMPLATE_OBJECT Procedure Parameters

Parameter Description

Parameter	Description
refresh_template_ name	Name of the deployment template from which you are dropping the object.
object_name	Name of the template object to be dropped.
object_type	The type of object that is to be dropped. Objects of the following type may be specified: `SNAPSHOT PROCEDURE` `INDEX FUNCTION` `TABLE PACKAGE` `VIEW PACKAGE BODY` `SYNONYM MATERIALIZED VIEW` `SEQUENCE DATABASE LINK` `TRIGGER`

refresh_template_
name

Name of the deployment template from which you are dropping the object.

object_name

Name of the template object to be dropped.

object_type

The type of object that is to be dropped. Objects of the following type may be specified:

SNAPSHOT PROCEDURE

INDEX FUNCTION

TABLE PACKAGE

VIEW PACKAGE BODY

SYNONYM MATERIALIZED VIEW

SEQUENCE DATABASE LINK

TRIGGER

Exceptions

Table 8-283 DROP_TEMPLATE_OBJECT Procedure Exceptions

Exception	Description
miss_refresh_ template	The deployment template name specified is invalid or does not exist.
miss_template_object	The template object specified is invalid or does not exist. Query the `DBA_REPCAT_TEMPLATE_OBJECTS` view to see a list of deployment template objects.