DROP RESTORE POINT

Purpose

Use the DROP RESTORE POINT statement to remove a normal restore point or a guaranteed restore point from the database.

  • You need not drop normal restore points. The database automatically drops the oldest restore points when necessary, as described in the semantics for restore_point. However, you can drop a normal restore point if you want to reuse the name.

  • Guaranteed restore points are not dropped automatically. Therefore, if you want to remove a guaranteed restore point from the database, then you must do so explicitly using this statement.

See Also:

CREATE RESTORE POINT, FLASHBACK DATABASE, and FLASHBACK TABLE for information on creating and using restore points

Prerequisites

To drop a normal restore point, you must have the SELECT ANY DICTIONARY, FLASHBACK ANY TABLE, SYSBACKUP, or SYSDG system privilege. To drop a guaranteed restore point, you must have the SYSDBA, SYSBACKUP, or SYSDG system privilege.

Syntax

drop_restore_point::=

Description of drop_restore_point.gif follows
Description of the illustration drop_restore_point.gif

Semantics

restore_point Specify the name of the restore point you want to drop.

Examples

Dropping a Restore Point: Example The following example drops the good_data restore point, which was created in "Creating and Using a Restore Point: Example":

DROP RESTORE POINT good_data;