flash backÉÁ»ØÊý¾Ý

ʹÓÃflashback »Ö¸´±»deleteµÄÊý¾Ý
delete from tname t where t.type='5';
commit;
select * from tname; --4 rows selected
select sysdate from dual; -- È·¶¨Ò»¸öɾ³ý֮ǰµÄʱ¼äµã
flashback table tname to timestamp to_timestamp('2009-12-20 15:00:00','yyyy-mm-dd hh24:mi:ss');
--row movement is not enabled
alter table tname enable row movement;--ʹÓÃFlashback table µÄʱºò±ØÐëÏÈenable row movement
flashback table tname to timestamp to_timestamp('2009-12-20 15:00:00','yyyy-mm-dd hh24:mi:ss');
--Done
;
select * from tname; --5 rows selected
========
»Ö¸´Ê¹ÓÃdropɾ³ýµÄ±í£¬Ã»ÓÐʹÓÃpurge
flashback table tt to before drop;