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.

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.

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.

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 (X) to the right of the flashback query filter.