April 1999
Intermediate to advanced
552 pages
15h 39m
English
DBMS_REFRESH.DESTROY
Call the DESTROY procedure to destroy a snapshot group. For both Oracle7 and Oracle8, you call DESTROY as follows:
PROCEDURE DBMS_REFRESH.DESTROY (name IN VARCHAR2);
name is the name of the snapshot group to be destroyed.
Exception Name | Number | Description |
|---|---|---|
ORA-23404 | –23404 | Refresh group name does not exist. |
This procedure must be run from the snapshot site.