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 Table

Another new flashback feature introduced with the Oracle 10g database is Flashback Table. Flashback Table, much like Flashback Database, allows you to recover data to a specific point in time without restoring from a backup; however, the recovery is handled at the table level. When the Flashback Table feature is invoked, the data stored in the tables and all objects that are related to the table (indexes, constraints, triggers, and so on) are also restored. This new feature is extremely useful when a user accidentally inserts, updates, or deletes the wrong rows in a table or even accidentally drops a table if he or she has the proper privileges to do so.

In previous versions of the database, the recovery operation for a single ...

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