1.查看过去某时间被删除的数据 //test为表名,code为字段名
select * from test as of timestamp to_timestamp('2022-03-04 16:00:00', 'yyyy-mm-dd hh24:mi:ss') where code like '0000';
2.开启表的flash储存权限(行移动) //不开无法恢复
ALTER TABLE test ENABLE ROW MOVEMENT;
3.执行表的数据恢复
FLASHBACK TABLE test TO TIMESTAMP TO_TIMESTAMP('2022-03-04 16:00:00', 'YYYY-MM-DD HH24:MI:SS');