BIG Biang teach you how to delete Oracle by mistake,

Today inadvertently on the Internet to see a message about the recovery of Oracle deleted data, found that it is very good, the following on my test report to you.

1. Select * FROM T_VIRADSL2 t//query T_VIRADSL2 for all data, you can see three data

2. Delete T_VIRADSL2//delete all data in T_VIRADSL2, three data disappears

3. Select * FROM T_VIRADSL2 t//No data.

4. INSERT INTO T_VIRADSL2 SELECT * from T_VIRADSL2 as of timestamp to_date (' 2011-01-19 15:28:00 ', ' yyyy-mm-dd hh24:mi:ss ') Mistakenly deleted data has been inserted into the table

5. Select * FROM T_VIRADSL2 t//See also three data.

Let's analyze the fourth step and note this sentence:

SELECT * from T_VIRADSL2 as of timestamp to_date (' 2011-01-19 15:28:00 ', ' yyyy-mm-dd hh24:mi:ss '), what do you mean, find T_VIRADSL2 in 2011 -01-19 15:28:00 All the data at this point in time, now that you've found it, you can do whatever you want to do.

Finally, thanks to Korea's Superman gas combination big Biang luv, Top

BIG Biang teach you how to delete Oracle by mistake,