Jan 092013
create restore point 
guarantee flashback database;
Be wary; guaranteed restore points consume space in your flash recovery area until (explicitly) dropped,
which can lead to embarrassing space errors if you forget they're there!

For a worked example of this in action, have a look at this article in Morgan’s library.

  2 Responses to “Creating a point of safety”

  1. Chris,

    I prefer to bookmark
    for Morgan’s library.

    See: the link you gave applies to Version 11.1 ( at the moment ), whereas
    applies to Version ( though they should not differ concerning this topic ).


    • Good point Matthias; I’ll have to start getting you to review my posts at this rate ;)

      Morgan’s library is one of my most used bookmarks!

      I’ve updated the link to the version.

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>