比如有以下误操作:
DROP TABLE drop_test; |
SELECT * FROM user_recyclebin WHERE original_name=‘drop_test’; |
那么现在就可以用如下语句进行恢复:
FLASHBACK TABLE drop_test TO BEFORE DROP |
比如有以下误操作:
DROP TABLE drop_test; |
SELECT * FROM user_recyclebin WHERE original_name=‘drop_test’; |
那么现在就可以用如下语句进行恢复:
FLASHBACK TABLE drop_test TO BEFORE DROP |