oracle误删除记录或者表的处理方法

1 误删除记录

insert into bd_floor_ys(
select * from bd_floor_ys as of timestamp to_Date('2017-08-28 00:00:01', 'yyyy-mm-dd hh24:mi:ss') where id='121396')   ;

 

2 误删除表

select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin;

flashback table "BIN$xH4ll5syQ7CCRHTUFA3USQ==$0" to before drop;

转载于:https://www.cnblogs.com/zhjx0521/p/7443134.html