Oracle recover deleted and submitted data ____oracle

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