O'Reilly logo

Oracle Database 12c The Complete Reference by Bob Bryla, Kevin Loney

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

image

CHAPTER29Using Flashback Queries

As part of its read consistency model, Oracle displays data that has been committed to the database. You can query data as it existed prior to a transaction being committed. If you accidentally COMMIT an errant UPDATE or DELETE, you can use this capability—called a flashback query—to see the data as it existed prior to the COMMIT. You can then use the results of the flashback query to restore the data.

To support flashback queries, your database must have Automatic Undo Management enabled, which is the default on Oracle Database 12c. Flashback queries can also be executed against remote databases.

Oracle attempts ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required