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
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset