时间:2021-07-01 10:21:17 帮助过:3人阅读
恢复
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