BIG biang teaches you how to delete oracle by mistake, biangoracle
Today, I accidentally saw a message on the Internet about oracle accidental deletion of data recovery, which is really helpful. Next I will report my test to you.
1. select * from t_viradsl2 t // query all data in t_viradsl2. Three data entries are displayed.
2. delete t_viradsl2 // delete all data in t_viradsl2 and the three data items disappear.
3. select * from t_viradsl2 t // no data.
4. insert into t_viradsl2 select * from t_viradsl2 as of timestamp to_Date ('2017-01-19 15:28:00 ', 'yyyy-mm-dd hh24: mi: ss ') // The accidentally deleted data has been inserted into the table.
5. select * from t_viradsl2 t // three more data entries are displayed.
Let's analyze the fourth step. Pay attention to this sentence:
Select * from t_viradsl2 as of timestamp to_Date ('2017-01-19 15:28:00 ', 'yyyy-mm-dd hh24: mi: ss'). What does that mean, find all the data at the time point t_viradsl2 at 15:28:00. Now that you have found the data, you can do everything you want.
Finally, I would like to thank South Korea's popular big biang Quan zhilong and top