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>