The following opinions expressed in this post are my own and in no way connected to my employer.
List the Restore Points from V$RESTORE_POINT View:
SELECT NAME, SCN, TIME, DATABASE_INCARNATION#, GUARANTEE_FLASHBACK_DATABASE, STORAGE_SIZE FROM V$RESTORE_POINT WHERE GUARANTEE_FLASHBACK_DATABASE='YES';
Drop Restore Point:
DROP RESTORE POINT <RESTORE_POINT_NAME>;
Comments