|Oracle® Database SQL Language Reference
11g Release 1 (11.1)
|PDF · Mobi · ePub|
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.
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;