oracle误删除后恢复 oracle flashback

1.查看数据

select * from xxxx as of timestamp to_timestamp('2020-08-07 09:28:00','YYYY-MM-DD hh24:mi:ss');

2.打开行移动

alter table xxxx enable row

3.闪回

flashback table xxxx to timestamp TO_TIMESTAMP('2020-08-07 09:28:00','YYYY-MM-DD hh24:mi:ss');

4.关闭行移动

alter table xxxx disable row movement;