Oracle7 Server SQL Reference

DROP SNAPSHOT LOG

Purpose

To remove a snapshot log from the database.

Prerequisites

Since a snapshot log consists of a table and a trigger, the privileges that authorize operations on it are the same as for a table. To drop a snapshot log, you must have the privileges listed for the DROP TABLE command later in this chapter. You must also have the privileges to drop a trigger from the snapshot log's master table. For information on these privileges, see the DROP TRIGGER command

Syntax

Keywords and Parameters

schema

is the schema containing the snapshot log and its master table. If you omit schema, Oracle7 assumes the snapshot log and master table are in your own schema.

table

is the name of the master table associated with the snapshot log to be dropped.

Usage Notes

After you drop a snapshot log, snapshots based on the snapshot log's master table can no longer be refreshed fast. They must be refreshed completely. For more information on refreshing snapshots, see the CREATE SNAPSHOT command

Example

The following statement drops the snapshot log on the PARTS master table: