BIG biang teaches you how to delete oracle by mistake, biangoracle

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