Oracle 当数据库的表没有drop操作就可以通过如下方式恢复表数据

--执行下列语句可查询出相关时间点

select * from sys.smon_scn_time order by time_dp desc;

 

 

--执行下列语句可将某个时间点的数据恢复

insert into oa2_inner_mail_tmp_0705_21 select * from oa2_inner_mail as of scn 2153227783;

 

 

create table oa2_inner_mail_tmp_0705_21 as select * from oa2_inner_mail as of scn 2153227783;