oracle10 恢复误删的数据

1、
SQL code --scn和time_mp<scn对应的时间>的联系
SELECT * FROM sys.smon_scn_time ORDER BY time_mp DESC;


2、
-- 取系统当前的scn SELECT dbms_flashback.get_system_change_number c_SCN FROM dual; --闪回查询 /*确认scn*/

3、
SELECT COUNT(*) FROM your_table AS OF SCN &SCN;


例子：
SQL> SELECT * FROM sys.smon_scn_time ORDER BY time_mp DESC;
SQL> SELECT dbms_flashback.get_system_change_number c_SCN FROM dual;
SQL> select count(*) from pa_param_item as of scn 9278948;
SQL> create table pa_param_data_test as select * from pa_param_data as of scn 9278948;