There are two methods: SCN and time stamp two methods of recovery.
I. Recovering deleted and committed data through the SCN
1. Obtain the SCN number of the current database
Select Current_scn from V$database; (Switch to SYS user or System user query)
The SCN number to be queried is: 1499223
2. Check the SCN before the current SCN number
SELECT * from table name as of SCN 1499220; (Determine if the deleted data exists, and if so, recover the data; if not, continue to reduce the SCN number)
3. Recover deleted and submitted data
Flashback table name to SCN 1499220;
Ii. recovery of deleted and submitted data by time
1. Query the current system time
Select To_char (sysdate, ' Yyyy-mm-dd hh24:mi:ss ') from dual;
2. Query the data at the point in time to delete data
SELECT * from table name as of timestamp To_timestamp (' 2013-05-29 15:29:00 ', ' yyyy-mm-dd hh24:mi:ss '); (if not, continue narrowing)
3. Recover deleted and submitted data
Flashback table name to timestamp to_timestamp (' 2013-05-29 15:29:00 ', ' yyyy-mm-dd hh24:mi:ss ');
Note: If you execute the above statement, an error occurs. Can attempt to execute ALTER TABLE name enable row movement;//allow change timestamp
Oracle Delete Data Recovery