Oracle误删表恢复操作

scott用户下：

SQL> select * from tab;
TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
BONUS                          TABLE   
DEPT                           TABLE   
EMP                            TABLE   
REGISTER                       TABLE   
SALGRADE                       TABLE   

SQL> drop table dept;   #误删除操作
Table dropped

SQL> select * from tab;
TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
BIN$zRtB2YqWTT6n9d64Bjzu8g==$0 TABLE   
BONUS                          TABLE   
EMP                            TABLE   
REGISTER                       TABLE   
SALGRADE                       TABLE   

SQL> FLASHBACK TABLE dept TO BEFORE DROP;    #flashback操作
Done

SQL> select * from tab;
TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
BONUS                          TABLE   
DEPT                           TABLE   
EMP                            TABLE   
REGISTER                       TABLE   
SALGRADE                       TABLE   

SQL>