Oracle7 Server SQL Reference

DROP SNAPSHOT

Purpose

To remove a snapshot from the database.

Prerequisites

The snapshot must be in your own schema or you must have DROP ANY SNAPSHOT system privilege. You must also have the privileges to drop the internal table, views, and index that Oracle7 uses to maintain the snapshot's data. For information on these privileges, see the DROP TABLE command

the DROP VIEW command

, and the DROP INDEX command

Syntax

Keywords and Parameters

schema

is the schema containing the snapshot. If you omit schema, Oracle7 assumes the snapshot is in your own schema.

snapshot

is the name of the snapshot to be dropped.

Usage Notes

When you drop a simple snapshot, if it is the least recently refreshed snapshot of a master table, Oracle7 automatically purges the master table's snapshot log of the rows needed only to refresh the dropped snapshot.

When you drop a master table, Oracle7 does not automatically drop snapshots based on the table. However, Oracle7 returns an error message when it tries to refresh a snapshot based on a master table that has been dropped.

Example

The following statement drops the snapshot PARTS owned by the user HQ: