Accidentally deleted thousands of table rows - advice please!
716107May 23 2011 — edited May 23 2011Hi Everyone,
I've just done something incredibly stupid.
I was meaning to run:
delete from location where id='zzz' AND (endd_date='xxxx' OR endd_date='yyyyy')
but I accidentally ran:
delete from location where id='zzz' AND endd_date='xxxx' OR endd_date='yyyyy'
in isqlplus. I did not commit. I immediately tried the rollback and undo commands. I then attempted an sqlplus exit FAILURE to no avail. The rows are gone. I do not have flashback recovery enabled. I don't know what to do to get this data back. Advice greatly appreciated! Google is not making any sense.
I would also appreciate some advice on what to do next time this happens! Thanks!!