oracle 数据库还原
--查询出操作语句及时间点
select * from v$sqlarea order by FIRST_LOAD_TIME desc ;
--创建表读取出时间点的数据
CREATE TABLE sas_role_rel_bak AS
SELECT * from sas_role_rel
as of timestamp to_timestamp('2020-05-14/15:58:06','yyyy-mm-dd hh24:mi:ss') ;
--最后将原表清空,将创建的表数据插入原表
delete from sas_role_rel;
INSERT INTO sas_role_rel SELECT * FROM sas_role_rel_bak;