Oracle 闪回查询

--使用闪回查询获取丢失的行

select *
from sys_user as of timestamp to_timestamp('2017-11-22 17:55:00', 'yyyy-mm-dd hh24:mi:ss')
where name = 'lee';

--使用闪回查询还原丢失的行

insert into sys_user
(select *
from sys_user as of timestamp to_timestamp('2017-11-22 17:55:00', 'yyyy-mm-dd hh24:mi:ss')
where name = 'lee');

转载于:https://www.cnblogs.com/liyingxian5/p/8066684.html