首页 > 代码库 > oracle delete 后的还原数据 靠谱

oracle delete 后的还原数据 靠谱



一,查找大致时间点的SCN

select timestamp_to_scn(to_timestamp(‘2015-01-05 21:20:00‘,‘yyyy-mm-dd hh24:mi:ss‘)) from dual;

二,查询被删除的数据,并还原
insert into ERP_FACILITY_MAP  select * from ERP_FACILITY_MAP as of scn 1603128909

select * from ERP_FACILITY_MAP

oracle delete 后的还原数据 靠谱