--检查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;