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

Get Oracle® Database 10g Insider Solutions now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.