CHAPTER30Flashback—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. The following sections describe the 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 ...
Get Oracle Database 12c 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.
