1.查看误操作前的数据(RULE_EXPERT_INFO 操作表名称,时间是操作的大概时间,order by RECORD_TIME DESC 可有可无)
select * from RULE_EXPERT_INFO as of timestamp
to_timestamp('2021-9-14 01:15:25 ', 'YYYY-MM-DD HH:MI:SS ') order by RECORD_TIME desc;
2.撤销操作前启用行移动功能(必须)(RULE_EXPERT_INFO 操作表名称)
alter table RULE_EXPERT_INFO enable row movement;
3.执行撤销操作 (RULE_EXPERT_INFO 操作表名称,时间于第一步相同)
flashback table RULE_EXPERT_INFO to timestamp TO_TIMESTAMP('20210914 01:15:25','YYYYMMDD HH24:MI:SS');