Having played around with Flashback Data Archive in 11g, I figured I would get through the 12c enhancements pretty quickly. I didn’t account for the fact I’m a donkey and can’t see the wood for the trees. Luckily, I know some people who aren’t stupid and they gave me a nudge in the right direction, allowing me to spot my silly mistake. Thanks Bjoern and Connor! 🙂
So after lots of wasted time, here is the article.
For the most part, it’s an evolution, but the new bits are pretty darn cool. I guess a lot of people will focus on two main things:
- It is now a free feature, provided you don’t use compression, available in all versions. The change to use no compression by default has been back-ported to 18.104.22.168, so it’s free there too, which is nice!
- The contents of contexts can now be stored in the flashback archive, so you can have access to the USERENV and custom context values that were set in the session when the DML was processed. This makes it possible to replace all those crappy old audit triggers with FDA!
There’s some other stuff in there that’s kind-of nice too. I think it’s worth checking it out, especially at its new price. 🙂