Oracle Flashback Technologies-Flash back to the drop table

Oracle Flashback Technologies-Flash back to the drop table

In oracle10g, when a table is dropped, the table is not actually deleted, and the support is rename and placed in RecycleBin.

#新建一个表y2, used to test

Sql> CREATE TABLE y2 as select * from All_tables; Table created. Sql> Select COUNT (*) from Y2;  COUNT (*)----------      3598

#删除表

Sql> Show recyclebinsql> drop table y2; Table dropped. Sql> Show recyclebinoriginal name    recyclebin name                OBJECT TYPE  DROP time------------------------------ -----------------------------------------------Y2               bin$gsug65h6lkdgu7wmcgqm8g==$0 TABLE        2015-06-23:08:04:05sql> Select COUNT (*) from Y2;select count (*) from Y2                     *error on line 1:ora-00942:table or view D OES not exist

#闪回被drop的表

Sql> Flashback table Y2 to before drop; Flashback complete. Sql> Select COUNT (*) from Y2;  COUNT (*)----------      

Oracle Flashback Technologies-Flash back to the drop table