Well, not really. It did not actually save my life. I had backups and I had a backup of the backup – but flashback was pretty good in this 18 million row table!
I thought I was running “SELECT COUNT(1) from proddta.F43199”, but it seems that I ran “DROP TABLE PRODDTA.F43199”…
Okay, yes… Message returned from SQL developer confirms my mistake.
Panic sets in, although I have a distant memory of the concept of flashback
I perform a quick google and then courageously execute:
flashback table proddta.f43199 to before drop ;
Then I get confirmation “table PRODDTA.F43199 succeeded” – YES!!!!
I also have my 18 million records.
Thanks oracle – brilliant
No comments:
Post a Comment