oracle误删除表后恢复数据

1.查出来你操作的时间

select r.FIRST_LOAD_TIME,r.* from v$sqlarea r Where sql_text Like '%update TABLENAME set sqlscript= %' order by r.FIRST_LOAD_TIME desc ;

2.保存到一张临时表 table t_table_recove上

create table t_table_recove as select * from TABLENAME as of timestamp to_timestamp('2017-12-27/10:21:04','yyyy-mm-dd hh24:mi:ss')

3.再恢复到原始表 Cf_Formuladefine

insert into TABLENAME select * from t_table_recove;