plsql操作中误删除数据，怎么恢复?

1.查看过去某时间被删除的数据 //tablename为表名，code为字段名

select * from tablename as of timestamp to_timestamp('2022-12-08 15:00:00', 'yyyy-mm-dd hh24:mi:ss') where code like '0000';

2.开启表的flash储存权限(行移动) //不开无法恢复
     

ALTER TABLE tablename ENABLE ROW MOVEMENT;

3.执行表的数据恢复
     

FLASHBACK TABLE tablename TO TIMESTAMP TO_TIMESTAMP('2022-12-08 15:00:00', 'YYYY-MM-DD HH24:MI:SS');