Executing a Flashback Query

View the data as it existed at a previous point in time by executing a flashback query on the Actions, Data submenu.

The default amount of time that you can flashback is 3 hours (or 180 minutes) but the actual amount is different for each database.

• Creating a Flashback Query
  Create a flashback query by using the Actions, Data submenu.
• Editing a Flashback Query
  Edit a flashback query by clicking the flashback query filter in an interactive report.
• Deleting a Flashback Query
  Delete a flashback query by using the flashback query filter dialog in an interactive report.

Creating a Flashback Query

Create a flashback query by using the Actions, Data submenu.

To execute a flashback query:

1. Click the Actions menu and select Data then Flashback.
2. In the Flashback field, enter the number of minutes.
3. Click Apply.

Editing a Flashback Query

Edit a flashback query by clicking the flashback query filter in an interactive report.

To edit a flashback query:

1. Click flashback query filter.
   The Flashback dialog appears.
2. Edit minute ago attribute.
3. Click Apply.

Deleting a Flashback Query

Delete a flashback query by using the flashback query filter dialog in an interactive report.

To delete a flashback query:

1. Click the flashback query filter.
   The Flashback dialog appears.
2. Click Delete.

Tip:

You can also click the Remove Flashback icon to the right of the flashback query filter.