Replication Management API Reference, 141 of 179

DROP_ALL_OBJECTS procedure

This procedure allows the DBA to drop all objects or specific object types from a deployment template.

Caution:
This is a dangerous procedure that cannot be undone.

Syntax

DBMS_REPCAT_RGT.DROP_ALL_OBJECTS (
   refresh_template_name   IN   VARCHAR2,
   object_type             IN   VARCHAR2 := NULL);

Parameters

Table 8-268 DROP_ALL_OBJECTS Procedure Parameters

Parameter Description

Parameter	Description
refresh_template_ name	Name of the deployment template that contains the objects that you want to drop.
object_type	If `NULL`, then all objects in the template are dropped. If an object type is specified, then only objects of that type are 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 that contains the objects that you want to drop.

object_type

If NULL, then all objects in the template are dropped. If an object type is specified, then only objects of that type are 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-269 DROP_ALL_OBJECTS Procedure Exceptions

Exception	Description
miss_refresh_ template	Specified deployment template name is invalid or does not exist.
bad_object_type	Object type is specified incorrectly. See Table 8-268 for a list of valid object types.