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

Advanced Flashback Features in Oracle Database 10g Release 2

In Oracle Database 10g Release 2, the flashback technology has been enhanced to provide greater flexibility with your recovery options. 10g Release 2 introduces two new features with Flashback Database and Flashback Table: flashback restore points and flashback across global database changes.

Flashback Restore Points

Flashback restore points are associated names that you define for a given point in time. Restore points, much like a transaction savepoint, allow you to flashback to a defined alias within your flashback history. By creating save points, users no longer have to investigate the SCN or timestamp of a specific operation before using the Flashback Table or Flashback Database ...

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