Oracle Flashback Technologies - 闪回被drop的表

SQL> create table y2 as select * from all_tables;

Table created.

SQL> select count(*) from y2;

  COUNT(*)
----------
      3598

SQL> show recyclebin
SQL> drop table y2;

Table dropped.

SQL> show recyclebin
ORIGINAL NAME    RECYCLEBIN NAME                OBJECT TYPE  DROP TIME
---------------- ------------------------------ ------------ -------------------
Y2               BIN$GSUg65H6LKDgU7wMCgqm8g==$0 TABLE        2015-06-23:08:04:05
SQL> select count(*) from y2;
select count(*) from y2
                     *
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> flashback table y2 to before drop;

Flashback complete.

SQL> select count(*) from y2;

  COUNT(*)
----------
      3598

SQL> show recyclebin
SQL>