Oracle quick recovery of a row of data deleted from a table

How can I flash it back when I delete some table data? Some data is inserted to the table within 20 minutes.

 

Query by SCN number

Select a, B, c, versions_xid, versions_starttime, versions_endtime,
Versions_startscn, versions_endscn, versions_operation
From test versions between SCN 339493 and 339635

Time-based

From test versions between Timestamp
To_date ('2017-09-23 16:09:00 ', 'yyyy-mm-dd hh24: MI: ss ')
And to_date ('2017-09-23 16:45:00 ', 'yyyy-mm-dd hh24: MI: ss ')

 

Select a, B, c, versions_xid, versions_starttime, versions_endtime,
Versions_startscn, versions_endscn, versions_operation
From test versions between timestamp minvalue and maxvalue
This record flashes back all data

 

Insert into Ba. t_wap_finance_analyz
Select *

From ba. t_wap_finance_analyz versions between Timestamp
To_date ('2017-12-21 9:00:00 ', 'yyyy-mm-dd hh24: MI: ss ')
And to_date ('2017-12-21 11:00:00 ', 'yyyy-mm-dd hh24: MI: ss ')
Where f_yearweek = '20140901'

 

It keeps the records before the last change of each row in the table, right?

Db_recovery_file_dest

Db_recovery_file_dest_size

 

The above figure shows that if undo cannot flash back data and you cannot determine the time, you can see that your data is in the recovery area. If yes, you can insert the data back to the original table based on the time mark.