|Oracle® Database SQL Language Reference
11g Release 2 (11.2)
Part Number E17118-03
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
To drop a normal restore point, you must have either the
DICTIONARY or the
TABLE system privilege. To drop a guaranteed restore point, you must have the
SYSDBA system privilege.
restore_point Specify the name of the restore point you want to drop.
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;