sql恢复删除的数据

insert into 表名
select *
from 表名 as of timestamp to_timestamp(‘2020-07-10 12:10:37’, ‘yyyy-mm-dd hh24:mi:ss’)
where id not in (select id from 表名);
commit;

–查询还原时间点数据

select * from t_sys_organization as of timestamp to_timestamp(‘2019-03-12 15:40:00’,‘yyyy-mm-dd hh24:mi:ss’)
–还原数据

flashback table t_sys_organization to timestamp to_timestamp(‘2019-03-12 15:40:00’,‘yyyy-mm-dd hh24:mi:ss’);
–如果执行上面报错则执行语句"运行修改时间戳"

alter table t_sys_organization enable row movement;