Name
DBMS_REPCAT.DROP_SNAPSHOT_REPGROUP
Synopsis
The DBMS_REPCAT package’s DROP_SNAPSHOT_REPGROUP procedure is the counterpart to the CREATE_SNAPSHOT_REPGROUP procedure. This procedure drops an existing snapshot replication group and, optionally, all of its contents.
PROCEDURE DBMS_REPCAT>DROP_SNAPSHOT_REPGROUP
(gname IN VARCHAR2,
drop_contents IN BOOLEAN := FALSE);Parameters
Parameter Name | Description |
|---|---|
gname | Name of the snapshot group. |
drop_contents | If TRUE, objects in gname are dropped. If FALSE (the default) they are simply no longer replicated. |
Exceptions
Exception Name | Number | Description |
|---|---|---|
missingrepgroup | –23373 | Replication group gname does not exist. |
nonmaster | –23313 | Calling site is not a snapshot site. |
Restrictions
If drop_contents is set to FALSE, the triggers created to support snapshot modifications remain.