3.7.12 Executing a Flashback Query

Execute a flashback query by selecting Flashback from the Actions, Data submenu. A flashback query enables you to view the data as it existed at a previous point in time.

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

3.7.12.1 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 thenFlashback.
  2. In the Flashback field, enter the number of minutes.
  3. Click Apply.

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

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