Oracle 10g: Is it possible to designate a undo point?

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,

Kyle

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

StackExchange Database Administrators Q#10550, answer score: 5