top of page
Writer's pictureblkrishnarao

Drop Flashback Restore Point | Oracle Database

Updated: Apr 16

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>;

2 views0 comments

Recent Posts

See All

Comments


bottom of page