The flashback feature in oracle database allows you to recover the deleted data. The following example shows how to recover the data at a point of time using the flashback feature:
This insert statement is to recover the data at the specified point of time. Now we have to get the system change number (SCN).
Insert into temp_table
select * from tablename
AS OF TIMESTAMP ('01-OCT-12 00:00:00','DD-MON-YY HH24: MI: SS'));
This query gives the SCN number. Let say the SCN number is 20560806678. The final step is to recover the data and insert into the temp table.
SELECT DBMS_FLASHBACK. GET_SYSTEM_CHANGE_NUMBER FROM dual;
INSERT INTO temp_table
(SELECT * FROM tablename AS OF SCN 20560806678);