Oracle accidental deletion and data recovery

1. Check the system version number SCN according to the time point:

Select timestamp_to_scn (to_timestamp ('2017-01-07 11:20:00 ', 'yyyy-MM-DD hh: MI: ss') from dual

2. Check whether the data at the SCN time point of the table to be deleted is to be restored:
Select count (*) from ct_sal_ordertosaleissue as of SCN 44482681

3. Create a table that temporarily saves data:
Create Table temp1 as select * From ct_sal_ordertosaleissue

4. Insert the data before the temporary data table is accidentally deleted:
Insert into temp1 select * From ct_sal_ordertosaleissue as of SCN 44482681

5. Insert deleted data from the temporary table to the original table:
Insert into ct_sal_ordertosaleissue select * From temp1