Thank you
BC, June 02, 2016 - 3:57 pm UTC
Thank you so much for the detailed explanation about the options and license.
I had thought about Flashback Data Archive and created a ticket with Oracle Support to determine if it is an option in our current license.
You guys are the best, thank you
BC
MT, MI
Is Flashback Data Archive completely transparent?
Matthew McPeak, June 02, 2016 - 9:25 pm UTC
Is Flashback Data Archive as transparent as CDC was?
For example, we used CDC to monitor tables that are owned by a 3rd party application (and have not broken that application by doing so, so far).
But, if we move those tables into a FDA, isn't that more invasive / less transparent to the application? E.g., might we not break their patching process with ORA-55610 errors due to limited DDL support for tables in FDAs?
Personally, I find Oracle's desupport of CDC outrageous. It's like them saying "we have a better product for indexing so we're going to deprecate the CREATE INDEX command and charge you for the new, improved way".
June 03, 2016 - 4:01 am UTC
Is Flashback Data Archive as transparent as CDC was?
Possibly not as much as so, although that's dependent on the version of the database. Conversely, I see you've omitted the large number of restrictions placed upon you if you opt for the CDC route :-)
Options for Autonomous Database
John, July 03, 2022 - 4:52 pm UTC
While Flashback Data Archive is a perfect option for this kind of functionality, it is sadly not available for Autonomous Database. Are there any alternative options for this type of database?
July 05, 2022 - 12:25 am UTC
FDA is *coming* for autonomous, but is not there yet (as I write this).
In the interim, perhaps a trigger based solution but one that still allows automation of the process
https://github.com/connormcd/audit_utility