Perform a Flashback Database operation

1.在ldy用户下，删除一张表，删除时间是9:24以后
 SQL> select to_char(sysdate,'yyyymmdd hh24:mi:ss') ttime from dual;
 
 TTIME
 -----------------
 20121112 09:24:41
 
 SQL> select count(*) from TESTDEL2;
 
   COUNT(*)
 ----------
    3000000
 
 SQL> drop table TESTDEL2 purge;
 
2.闪回数据库到删除前的状态
 shutdown immediate;
 startup mount;
 FLASHBACK DATABASE  TO TIMESTAMP to_timestamp('20121112 09:24:41', 'yyyymmdd hh24:mi:ss');
 alter database open resetlogs;
 
3.重新用ldy用户连接，查看被删除的表已闪回
 SQL> select count(*) from TESTDEL2;
 
   COUNT(*)
 ----------
    3000000