1. 查看表操作历史记录
select * from v$sqlarea;
找到删除的操作和操作时间
LAST_LOAD_TIME
比如“2019-01-28 11:30:00”
2. 利用Oracle的快照查找上述时间点的数据
select * from tableName as of timestamp (systimestamp - interval '30' minute)
或
select * from tableName as of timestamp to_timestamp('2019-01-28 11:30:00','YYYY-MM-DD HH24:MI:SS')
如果要加查询条件,可以
select * from (select * from tableName as of timestamp to_timestamp('2019-01-28 11:30:00','YYYY-MM-DD HH24:MI:SS')
) t where t.字段名称='查询条件'
3.查询到指定时间段的数据,再把查询到的数据复制到原来的表中。
insert into table_name_new select * from (select * from tableName as of timestamp to_timestamp('2019-01-28 11:30:00','YYYY-MM-DD HH24:MI:SS')
) t where t.字段名称='查询条件'