Oracle数据恢复

SELECT *
　FROM FLASHBACK_TRANSACTION_QUERY t where t.table_name = 'TABLE_OPERATION'

insert into table_operation2  select * from table_operation as of timestamp 
to_timestamp('2009-9-21 09:00:00','yyyy-mm-dd hh24:mi:ss') where student_id in
(                       
    select t.student_id from table_operation t 
)

create table temptable as select * from table_operation as of timestamp to_timestamp('2009-9-21 09:00:00','yyyy-mm-dd hh24:mi:ss')

alter table jlxxt.table_operation enable row movement;
--alter database flashback on;
--flashback table jlxxt.table_operation to timestamp to_timestamp('2009-09-21 09:20:00','yyyy-mm-dd hh24:mi:ss');
--create table houhuitable as select *  from (select table_operation.* ,rownum rs from table_operation ) where rs>0
flashback table jlxxt.table_operation to timestamp to_timestamp('2009-09-22 08:06:00','yyyy-mm-dd hh24:mi:ss');
--