Query historical data in Oracle-Restore deleted data by mistake

Restore accidentally deleted data information:

1. Execute alter table table_name enable row movement;

2. Execute flashback table table_name to timestamp to_timestamp ('2017-05-24 14:59:36 ', 'yyyy-mm-dd hh24: MI: ss ');

Query historical operation data:

A reasonable method is to first find the accidentally deleted data from the flash back area, and then insert the accidentally deleted data into the original table.

1. Execute select * from a as of Timestamp sysdate-10/1440; 

This SQL statement finds all the data in Table A 10 minutes ago. 

Sysdate-10/1440 indicates that the number 1440 represents 1440 minutes a day before the current 10 minutes. 

If no distance time is written, the SQL statement can be written as: Select * from a as of Timestamp sysdate; to find all the data in Table A up to now.

 2. Find the accidentally deleted data from the data found above, and then insert it into the original table.