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;