[oracle] 闪回误删除表

删除表

SQL> drop table c##sapr3.test;

Table dropped.

SQL> select count(*) from  c##sapr3.test;
select count(*) from  c##sapr3.test
                               *
ERROR at line 1:
ORA-00942: table or view does not exist

恢复

SQL> flashback table c##sapr3.test to before drop;

Flashback complete.

SQL> select count(*) from  c##sapr3.test;

  COUNT(*)
----------
    123029

永久删除

SQL> drop table c##sapr3.test;

Table dropped.

SQL> purge table c##sapr3.test;

Table purged.

SQL> select count(*) from  c##sapr3.test;
select count(*) from  c##sapr3.test
                               *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> flashback table c##sapr3.test to before drop;
flashback table c##sapr3.test to before drop
*
ERROR at line 1:
ORA-38305: object not in RECYCLE BIN