O'Reilly logo

Oracle Database 12c The Complete Reference by Bob Bryla, 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

image

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

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