Friday, 15 March 2013

The day that oracle flashback saved my life

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:

Extending JDE to generative AI