4.6.12 Executing a Flashback Query

View the data as it existed at a previous point in time by running 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.

4.6.12.1 Creating a Flashback Query

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

To run a flashback query:

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

4.6.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 Flashback Duration (minutes).
3. Click Apply.

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