Online Documentation for SQL Manager for Oracle
Specifying flashback settings
Use this step to specify the table to flash back and the restore point.
(Available only when the Flashback table data mode was specified at the first step.)
The latest SCN is displayed at this field.
Select the needed schema from the drop-down list.
Specify the table you want to flash back.
This field displays the SCN of the chosen restore point. Type the value in only if you are sure the value is right.
Choose the flashback point from the whole database SCN list.
Select the flashback point from the list of restore points contained in the built-in restore point table.
EMS Manager restore point
Choose the flashback point from the list of restore points contained in SQL Manager restore point table.
Use this variant either to define the approximate date and time of the needed flashback point (Timestamp point), or the date and time interval to use the closest flashback point (Before current timestamp).
Click the Next button to proceed to the Previewing the data in the selected flashback point step of the wizard.