oracle误删除恢复

select * from gas_report_supply as of timestamp to_timestamp('2017-10-31 15:40:00','yyyy-mm-dd hh24:mi:ss')

insert into gas_report_supply
select * from gas_report_supply as of timestamp to_timestamp('2017-10-31 15:40:00','yyyy-mm-dd hh24:mi:ss')

alter table gas_report_supply enable row movement
--恢复表数据
flashback table gas_report_supply to timestamp to_timestamp('2017-10-31 15:40:00','yyyy-mm-dd hh24:mi:ss')
--关闭行移动功能
alter table gas_report_supply disable row movement