Jan 092013
 
create restore point 
"we_can_revert_to_with_oracle's"
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
    http://www.morganslibrary.org/library.html
    for Morgan’s library.

    See: the link you gave applies to Version 11.1 ( at the moment ), whereas
    http://www.morganslibrary.org/reference/restore_points.html
    applies to Version 11.2.0.3 ( though they should not differ concerning this topic ).

    Cheers
    Matthias

    • 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 11.2.0.3 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>

(required)

(required)