1.根據時間點查系統版本號scn:
select timestamp_to_scn(to_timestamp('2013-01-07 11:20:00','YYYY-MM-DD HH:MI:SS')) from dual
2.查看被誤刪數據的表scn時間點的數據是否要恢復的數據:
select count(*) from ct_sal_orderToSaleIssue as of scn 44482681
3.創建臨時保存數據的表:
create table temp1 as select * from ct_sal_orderToSaleIssue
4.往臨時數據表插入被誤刪前的數據:
insert into temp1 select * from ct_sal_orderToSaleIssue as of scn 44482681
5.從臨時表往原表上插入被刪除的數據:
insert into ct_sal_orderToSaleIssue select * from temp1