Oracle Flashback Table enables you to rewind one or more tables back to their contents at a previous time without affecting other database objects. Thus, you can recover from logical data corruptions such as table rows added or deleted accidentally. Unlike point-in-time recovery, the database remains available during the flashback operation.
For this example, you use Flashback Table on the employees
table in the hr
schema. Assume that an erroneous update shortly after October 23, 2005 at 15:30:00 has changed the lastname
column for all employees to an empty string, and you must return the original lastname
values to the table.
This section contains the following topics: