I was wondering if it is possible to designate a point in time, then later "roll-it-back" to that state (undo DDL and DML changes). Maybe using a record of changes and then executing the reverse? Does Oracle have any features like this built in 10g or 11g?

Thanks in advance,


2 Answers 2


John has pointed you at the Flashback Query options useful from a developers point of view. If I read you correctly then you are probably looking for the Flashback Database and Restore Point functionality documented here which allows you to do precisely this. Flashback Database does have some requirements over and above the flashback query functionality (for example it requires a flash recovery area to be configured and extra disk space compared to a non-flashback database ).

  • Yep, this is what I'm looking for 100%. Thank you! Commented Jan 12, 2012 at 15:13

Take a look into flashback here. I think it was introduced in 10g and can be utilised to bring a table back to an earlier state, for example.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.