Name

DROP SNAPSHOT

Synopsis

DROP SNAPSHOT
[schema.]snapshot_name

Removes a snapshot (snapshot_name) from the database.

Notes

The snapshot to be dropped must be in your schema, or you must have the DROP ANY SNAPSHOT privilege to remove a snapshot from another schema. Note that if you drop the master table, the snapshot is not automatically dropped.

Example

The following example removes the snapshot emp_UK from the database:

DROP SNAPSHOT emp_UK

Get Oracle Database Administration: The Essential Refe now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.