Flashback saved my life

To recover I used...

create table reh_temp
as
select *
from table1
AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '60' MINUTE) where cs_date = to_date('22-mar-2009','dd-mon-yyyy')
;

I then did...

Insert into table1
Select * from reh_temp


My original cock up was...

Delete
from table1
where cs_date = to_date('22-mar-2009','dd-mon-yyyy');
COMMIT;