15、oracle误删数据恢复

目录

• oracle误删数据恢复
  • 1、delete删除数据
  • 2、drop删除表恢复

oracle误删数据恢复

1、delete删除数据

回滚到指定时间点的数据

select * from gscommtype as of timestamp to_timestamp('2019-08-28 23', 'yyyy-mm-dd hh24');

2、drop删除表恢复

select object_name,        original_name,        partition_name,        type,        ts_name,        createtime,        droptime   from recyclebin t  where t.original_name like 'GGRISK%'  order by t.droptime desc;

--从回收站恢复

flashback table "BIN$fuqp9b5k2IPgUAB/AQDglg==$0" to before drop;