摘要:
在9i上执行的操作查询test表中记录select * from test;删除test表中记录delete from test;获得过去的会话exec dbms_flashback.disable;查询出3分钟前这个test表的情况select * from test as of timestamp(systimestamp - interval '3' minute );将查出的记录插入到误删除数据的表中insert into test select * from test as of timestamp(systimestamp - interval '30 阅读全文
posted @ 2011-11-14 11:11
流浪者的飘
阅读(219)
评论(0)
推荐(0)

浙公网安备 33010602011771号