Oracle9i Replication Management API Reference
Release 1 (9.0.1)

Part Number A87502-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

DBMS_REPCAT_RGT, 24 of 33


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 materialized view 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 re-instantiate 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 23-52 DROP_TEMPLATE_OBJECT Procedure Parameters
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

INDEX

TABLE

VIEW

SYNONYM

SEQUENCE

PROCEDURE

FUNCTION

PACKAGE

PACKAGE BODY

TRIGGER

DATABASE LINK  

Exceptions

Table 23-53 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. 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback