Oracle Database Error Deletion recovery method

If only some of the data is deleted by mistake or a piece of data can be

1. Select * from the error deletion indicates that as of timestamp to_date (' Recovery date seconds ', ' Recovery time format ') where query condition ;

Example: SELECT * from EMP as of timestamp to_date (' 2014-11-27 16:20:00 ', ' yyyy-mm-dd hh24:mi:ss ') where Ename= ' Scott ' Query to data that was mistakenly deleted

2, the query out of the data export, in the import table;

Two. If all data is deleted by mistake;

1, insert into mistakenly delete indicates that select * from the error delete indicates as of timestamp to_date (' 2014-11-27 16:28:00 ', ' Yyyy-mm-dd hh24            : Mi:ss ') where query condition ; Mistakenly deleted data has been inserted into the table

Oracle Database Error Deletion recovery method