set time on

create table ygzhou.flash(id int);

begin

for i in 1..20 loop

insert into ygzhou.flash values(i);

end loop;

commit;

end;

/

delete from ygzhou.flash where id>8 or id <5;

Flashbackup:

1、create table ygzhou.flash_back as select * from ygzhou.flash as of timestamp to_timestamp('2011-11-12 23:00:00','yyyy-mm-dd hh24:mi:ss);

2、create table temp as select * from ygzhou.falsh_back where id not in (select id from ygzhou.flash);

3、insert into ygzhou.flash select * from temp;

4、drop table temp/ygzhou.flash_back purge;

ITPub博客

Flashback data