plsql误操作表（增删改）的数据恢复(闪回操作)

plsql误操作表（增删改）的数据恢复

--允许行移动
alter table pms_app_notice enable row movement;
--查询指定时刻的数据
select * from pms_app_notice as of timestamp to_timestamp('2018/9/15 14:39:00','yyyy-mm-dd hh24:mi:ss');
--闪回恢复数据
flashback table pms_app_notice to timestamp to_timestamp('2018/9/15 14:39:00','yyyy-mm-dd hh24:mi:ss');

--关闭行移动

alter table cloud_agent_profit_detail DISABLE row movement;

--添加查询条件

SELECT * FROM table AS OF  TIMESTAMP TO_TIMESTAMP('2019/06/27  16:30:00', 'yyyy-mm-dd hh24:mi:ss')

WHERE id= '903410815847021';

详情:https://blog.csdn.net/hdblocal/article/details/53376566