[oracle] 闪回误删除表

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

 

[oracle] 闪回误删除表

标签：ash   ack   hba   sel   删除   oracl   back   rom   view