oracle中及时找回被删除的数据
<div class="iteye-blog-content-contain" style="font-size: 14px">
数据库回闪
select * from whir$t3068 as of timestamp to_timestamp( '2012-03-30 9:00:00' , 'yyyy-mm-dd hh24:mi:ss' )

select * from whir$t3068 as of timestamp sysdate-750/1440;

flashBack table scheme.whir$t3068 to timestamp(timeVariable,'2012-03-30 09:mi:ss')


********************这个效果很好***************************
先执行SQL查询出来被删除的数据
select * from 表名 as of timestamp sysdate-1/12

在把数据添加到删除的表中
insert into biao select  * from 表名 as of timestamp sysdate-1/12


</div>