DROP_MVIEW_REPOBJECT Procedure

DROP_M VIEW_REPOBJECT Procedure

This procedure drops a replicated object from a materialize d view site.

Syntax

DBMS_REPCAT.DROP_MVIEW_REPOBJECT ( 
   sname          IN   VARCHAR2, 
   oname          IN   VARCHAR2, 
   type           IN   VARCHAR2, 
   drop
_objects   IN   BOOLEAN  := false);

Parameters

Table 18-79 DROP_MVIEW_REPOBJECT Procedure Parameters

Para meter	Description
sname	Name of the schema in which the object is located.
oname	Name of the object that you wan t to drop from the replication group.
type	Type of the object that you want to d rop. The following types are supported: FUNCTION SNAPSHOT < /a>INDEX SYNONYM INDEXTYPE TRIGGER OPERATOR TYPE PACKAGE TYPE BODY PACKAGE BODY VIEW PR OCEDURE Use `SNAPSHOT` to drop a materialized view. < /td>
drop_objects	By default, the object remains in its associated schema, but is dropped from its associated replication group. To completely remove the object from its schema at the current materialized view site, set th is parameter to `true`. If the parameter is set to `true`, the object is dropped from the database at the mater ialized view site.

Exceptions

Table 18-80 DROP_MVIEW_REPOBJECT Procedure Exceptions

< td class="Formal">

nonmview

Exception	Description
Invocation site is not a materialized view site.
missingobject	Specified object does not exist.
typefailure	Specified type parameter is not supported.