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.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access