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 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.
The database should be using Automatic ...