Oracle 闪回恢复数据,及时解决误删除问题Drop Delete

Oracle 闪回恢复数据,及时解决误删除问题Drop  Delete

 

1. 误删除数据闪回恢复--Delete

delete from   tmps.mac_t3 ;
commit;

insert into    tmps.mac_t4 (select * from  tmps.mac_t3 as of timestamp(sysdate - 5/1440) );  --5分钟以前的数据
 

2.误删除Table 闪回恢复--Drop

drop table  tmp2.mac_t3   
flashback  table   tmp2.mac_t3 to before drop