oracle中及时找回被删除的数据
oracle中及时找回被删除的数据数据库回闪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')www.zzzyk.com********************这个效果很好***************************先执行SQL查询出来被删除的数据select * from 表名 as of timestamp sysdate-1/12在把数据添加到删除的表中insert into biao select * from 表名 as of timestamp sysdate-1/12