To use flashback, first start row movement:
ALTER TABLE name enable row movement;
Recover deleted and submitted data through the SCN
1. Get the SCN number of the current database
Select Current_scn from V$database; (Switch to SYS user or System user query)
The SCN number that you queried is: 1499223
2, query the current SCN number before the SCN
SELECT * from table name as of SCN 1499220; (Determine whether the deleted data exists and, if so, restore the data; if not, continue narrowing the SCN number)
3. Recover deleted and submitted data
Flashback table name to SCN 1499220;
Ii. recovery of deleted and submitted data through time
1, query the current system time
Select To_char (sysdate, ' Yyyy-mm-dd hh24:mi:ss ') from dual;
2, query the data to delete the point of time
SELECT * from table name as of timestamp To_timestamp (' 2013-05-29 15:29:00 ', ' yyyy-mm-dd hh24:mi:ss '); (if not, continue to narrow the scope)
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 the above statement is executed, an error occurs. You can attempt to execute the ALTER TABLE name enable row movement; Allow Change time stamp