误删表数据恢复

--检查undo时间（要在undo的时间范围内）
show parameter undo

--将被删除的内容写入新表
create table zhangxl.flashback_table_20180712 as
select * from zhangxl.flashback_table as of timestamp to_timestamp('2018-07-12 16:30:00','yyyy-mm-dd hh24:mi:ss')
where plan_id between 1107129 and 1107133;

--将新表数据写入被误删的表中
insert into zhangxl.flashback_table select * from zhangxl.flashback_table_20180712;
commit;

--检查被删的数据
select * from zhangxl.flashback_table where plan_id between 1107129 and 1107133;