SELECT * FROM tablename as of timestamp to_timestamp (' 2018-05-04 13:30:00 ', ' yyyy-mm-dd hh24:mi:ss ')
Querying data at this point in time
(It is possible because the system time and database time inconsistencies can not find the data so the time to query the database first
Select To_char (sysdate, ' Yyyy-mm-dd hh24:mi:ss ') from dual
According to this time, find the data before the data deletion time)
Find data can be exported to Excel, how to recover is not a problem
Flashback table TableName to timestamp to_timestamp (' 2018-05-04 13:30:00 ', ' yyyy-mm-dd hh24:mi:ss ')
Execute this statement to restore the data to this point in time
---------------------------------------------
Error: ORA-08189: cannot flash back to table because line move is not enabled
ALTER TABLE tablename enable row movement
Turn on line move function
Oracle deleted Data recovery by mistake