--

delete from mt2 a where a.empno > 7788;

commit;

-------
select * from mt2 as of timestamp to_timestamp('20080426 15:14:00','yyyymmdd hh24:mi:ss') where empno>7788;

insert into mt2 select * from mt2 as of timestamp to_timestamp('20080426 15:14:00','yyyymmdd hh24:mi:ss') where empno>7788;

SQL> drop table mt2;

表已删除。

SQL> select * from user_recyclebin;

OBJECT_NAME                    ORIGINAL_NAME                    OPERATION TYPE                     TS_NAME
------------------------------ -------------------------------- --------- ------------------------- ----------
BIN$yRqJ16A6Ro+fXh+PVX4VHw==$0 MT2                              DROP      TABLE                    USERS

SQL> flashback table mt2 to before drop;

闪回完成。