误删表名: T12
查看recyclebin的信息
SQL> col origninal_name format a15;
SQL> col type format a15;
SQL> select object_name,original_name,type from user_recyclebin;
OBJECT_NAME ORIGINAL_NAME TYPE
BIN$KswP8LfMaBjgUww4qMC6Tw==$0 ZW TABLE
BIN$Kswyt5BhaDLgUww4qMDxsg==$0 T12 TABLE
可以看到T12就是刚才被删除的表
4.闪回删除的表
SQL> flashback table T12 to before drop;
Flashback complete.
SQL> select count(*) from T12;
COUNT(*)
1