CHAPTER 28Flashback—Tables and Databases
As of Oracle Database 10g, you can use the flashback table and flashback database commands to simplify 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 ...
Get Oracle Database 10g The Complete Reference 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.
