oracle 数据恢复

u  查询出数据

select * from staff as of timestamp to_timestamp('2010-1-28 12:00:00','yyyy-mm-dd hh24:MI:ss')

u  复制新表

create table ft1 as select * from staff as of timestamp

to_timestamp('2010-1-28 12:00:00','yyyy-mm-dd hh24:MI:ss');

u  删除原表

Drop table staff ;

u  修改表名

alter table ft1 rename to staff ;