Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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,


share|improve this question
up vote 5 down vote accepted

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 ).

share|improve this answer
Yep, this is what I'm looking for 100%. Thank you! – PurpleAce1979 Jan 12 '12 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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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