PLSQL 误删表恢复及误删数据恢复

误删表恢复

1.查看你删除的是哪张表：

select * from user_recyclebin  t where DROPTIME >'2022-08-26 00:00:00' and t.original_name='JC_SPSX_ZJ_LS'  ;

2.恢复表

 flashback Table "BIN$5yF/rrzeDl3gUynBwcHPiA==$0" to before drop

误删数据恢复

1.查看你删除的数据：bm 为表名 code 为字段名

 select * from bm as of timestamp to_timestamp('2022-11-11 09:00:00', 'yyyy-mm-dd hh24:mi:ss') where code like '%陈%';

**2.开启表的flash储存权限 **

alter table bm enable row movement;

3.执行表的数据恢复

flashback table bm to timestamp to_timestamp('2022-11-11 09:00:00', 'yyyy-mm-dd hh24:mi:ss');