表数据操作:适用于undo尚有保存的闪回操作
1)闪回查询
a)查出scn
select timestamp_to_scn(to_date('2008-06-23 15:16:02','yyyy-mm-dd hh24:mi:ss')) from dual;
b)使用scn
select * from t as of scn 1202243;
2) 闪回数据
alter table delete_test enable row movement;
flashback table delete_test to timestamp (to_date('2008-06-23 11:07:30','yyyy-mm-dd hh24:mi:ss'));
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15116811/viewspace-545646/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15116811/viewspace-545646/