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