Oracle Flashback Archive Licensing Info...

Dave

As the licensing of the Oracle Flashback Features has changed over recent releases I wanted to provide a summary. In 12c Oracle has opened up basic usage of Flashback Data Archive which is a handy way to add data archiving capabilities to existing/legacy applications.

The cost part of Flashback Data Archive is now an Optimization feature which reportedly will reduce the disk space requirements by 2-4 times. This requires an Advanced Compression license to use.

10gR2

Edition/Licensing Info: http://docs.oracle.com/cd/B19306_01/license.102/b14199/editions.htm
Feature/OptionSE1SEEENotes
Flashback TableNNY 
Flashback DatabaseNNY 
Flashback Transaction QueryNNY 

11gR1

Edition/Licensing Info: http://docs.oracle.com/cd/B28359_01/license.111/b28287/editions.htm#CJACGHEB
Feature/OptionSE1SEEENotesFlashback TableNNYFlashback DatabaseNNYFlashback TransactionNNYFlashback Transaction QueryNNYFlashback Data Archive (Total Recall)NNYRequires Oracle Advanced Compression option

11gR2

Edition/Licensing Info: http://docs.oracle.com/cd/E11882_01/license.112/e47877/editions.htmFeature/OptionSE1SEEENotesFlashback TableNNYFlashback DatabaseNNYFlashback TransactionNNYFlashback Transaction QueryNNYOptimization for Flashback Data Archive history tablesNNYFor releases earlier than Oracle Database 11g Release 2 (11.2.0.4):You must license the Oracle Advanced Compression option to use Flashback Data Archive (formerly known as Total Recall). Beginning with Oracle Database 11gRelease 2 (11.2.0.4): You must license the Oracle Advanced Compression option to use Optimization for Flashback Data Archive history tables. Basic Flashback Data Archive—without history table optimization—is available in all editions.

12cR1

Edition/Licensing Info: http://docs.oracle.com/cd/E16655_01/license.121/e17614/editions.htmFeature/OptionSE1SEEENotesFlashback TableNNYFlashback DatabaseNNYFlashback TransactionNNYFlashback Transaction QueryNNYOptimization for Flashback Data ArchiveNNYBasic Flashback Data Archive is in all editions. Optimization for Flashback Data Archive requires EE and the Advanced Compression option.

You should also read:

Dave

Helpful Oracle Feature Matrix by RDBMS Version

I opened an SR recently while I was trying to get a feature to work in 19c... was politely directed to this resource... A listing of Oracle features and what version they're available in... Not sure when this was made available but I hope they…

Dave

Using PL/SQL region in Oracle Application Express

I'm still an Application Express beginner -- I'm used to web development that is closer to the HTML. While I am getting used to Apex's Regions and Templates sometimes you just need to build some HTML on your own. I have found some Apex helper…