Oracle Database accidental deletion recovery method, oracle Database accidental deletion

Oracle Database accidental deletion recovery method, oracle Database accidental deletion

1. If you just accidentally delete some data or a piece of data, you can use

1. If select * from is deleted by mistake, it indicates the where query condition as of timestamp to_Date ('recovery year, month, day, hour, minute, second ', 'recovery time format;

For example, select * from emp as of timestamp to_Date ('2017-11-27 16:20:00 ', 'yyyy-mm-dd hh24: mi: ss ') where ename = 'Scott '// query the deleted data by mistake.

2. Export the queried data in the import table;

2. If all data is deleted by mistake;

1. If the insert into statement is accidentally deleted, the statement "select * from statement" indicates "as of timestamp to_Date" ('2017-11-27 16:28:00 ', 'yyyy-mm-dd hh24: mi: ss ') where query condition; // you have inserted the deleted data into the table by mistake.