oracle中及时找回被删除的数据
<div 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>
