oracle知识点

删除表数据恢复

select * from tuser as of timestamp to_timestamp( '2017-12-11 17:00:00' , 'yyyy-mm-dd hh24:mi:ss' ) 查询某个时间段数据

--因为未启用行移动功能, 不能闪回表 所以开启


 alter table tuser enable row movement;
flashback table tuser to timestamp to_timestamp('2017-12-11 17:00:00','yyyy-mm-dd hh24:mi:ss');