Name

DBMS_REFRESH.DESTROY

Synopsis

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.

Exceptions

Exception Name

Number

Description

ORA-23404

–23404

Refresh group name does not exist.

Restrictions

This procedure must be run from the snapshot site.

Get Oracle Distributed Systems now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.