O'Reilly logo

Oracle Database 11g The Complete Reference by 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

CHAPTER 30Flashback—Tables and Databases

You can use the flashback table and flashback database commands to simplify and enhance your data-recovery efforts. The flashback table command automates the process of restoring a full table to its prior state. The flashback database command flashes back an entire database, and it requires modifications to the database status and its logs. In the following sections, you will see details on implementing these options.

The flashback table Command

The flashback table command restores an earlier state of a table in the event of human or application error. Oracle cannot restore a table to an earlier state across any DDL operations that change the structure of the table.

NOTE

The database should be using Automatic ...

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