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