April 1999
Intermediate to advanced
552 pages
15h 39m
English
DBMS_SNAPSHOT.UNREGISTER_SNAPSHOT (Oracle8 Only)
The UNREGISTER_SNAPSHOT procedure is the flip side of the REGISTER_SNAPSHOT procedure. You use UNREGISTER_SNAPSHOT when you need to manually unregister a snapshot. This procedure unregisters snapshots at the master site, regardless of whether they were registered manually or automatically.
PROCEDURE DBMS_SNAPSHOT.UNREGISTER_SNAPSHOT
(snapowner IN VARCHAR,
snapname IN VARCHAR2,
snapsite IN VARCHAR2)See the description of parameters under the REGISTER_SNAPSHOT procedure.
UNREGISTER_SNAPSHOT does not raise any exceptions and there are no restrictions on calling it. Unre gistering a snapshot has no effect on the snapshot itself.