1.查快照时间
select r.FIRST_LOAD_TIME,r.* from v$sqlarea r order by r.FIRST_LOAD_TIME desc ;
2.创建快照临时表
create table t_table_recove --新表
as
select * from prodcellfundsecujrnlhist--你操作的那张表
as of timestamp to_timestamp('2018-05-11/17:56:39','yyyy-mm-dd hh24:mi:ss');