O'Reilly logo

Oracle® Database 10g Insider Solutions by Richard Stroupe, John Kanagaraj, Arun Kumar R.

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

Flashback Transaction Query

Another new flashback query feature introduced with Oracle 10g is flashback transaction query. The new flashback transaction query feature allows users to review and/or recover modifications made to the database at the transaction level—meaning that users can use this new feature to diagnose and resolve logical problems, perform historical analysis, or even audit transactions from a single transaction or by all the transactions during a period of time. Prior to 10g, DBAs had to mine redo logs with LogMiner to extract specific transactional information to possibly correct or audit SQL statements. Now, with flashback transaction query, you can undo the effects of a bad transaction much more quickly than before by querying ...

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