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.
Parent topic: Customizing an Interactive Report Using the Actions Menu
Creating a Flashback Query
Create a flashback query by using the Actions, Data submenu.
To execute a flashback query:
- Click the Actions menu and select Data then Flashback.
- In the Flashback field, enter the number of minutes.
- Click Apply.
Parent topic: Executing a Flashback Query
Editing a Flashback Query
Edit a flashback query by clicking the flashback query filter in an interactive report.
To edit a flashback query:
Parent topic: Executing a Flashback Query
Deleting a Flashback Query
Delete a flashback query by using the flashback query filter dialog in an interactive report.
To delete a flashback query:
Tip:
You can also click the Remove Flashback icon to the right of the flashback query filter.
Parent topic: Executing a Flashback Query