Name
DBMS_REPCAT.DROP_SNAPSHOT_REPOBJECT
Synopsis
The DROP_SNAPSHOT_REPOBJECT procedure drops an object from a snapshot replication group at the snapshot site and, optionally, drops the object and its dependents as well.
PROCEDURE DBMS_REPCAT.DROP_SNAPSHOT_REPOBJECT
(sname IN VARCHAR2,
oname IN VARCHAR2,
type IN VARCHAR2,
drop_objects IN BOOLEAN := FALSE);.For parameter descriptions, see the CREATE_SNAPSHOT_REPOBJECT procedure.
Exceptions
Exception Name | Number | Description |
|---|---|---|
missingobject | –23308 | Object oname does not exist in master’s replication group gname. |
nonsnapshot | –23314 | Calling site is not a snapshot site. |
typefailure | –23319 | Invalid value for type. |
Restrictions
If the type parameter is SNAPSHOT and you do not set the drop_objects parameter to TRUE, replication triggers and associated packages remain in the schema, and deferred transactions (if any) remain in the deftran queue.