1

We have requirement to audit change history information,that includes capture old value and new value in transaction for update and delete(old value) operation. I have implemented triggers on a table but as number of tables are increasing I feel Oracle trigger option is not suggested. Could any one suggest some better option for audit change history.

Nick Krasnov
  • 26,886
  • 6
  • 61
  • 78
user2819874
  • 31
  • 1
  • 1
  • 2

1 Answers1

1

There are many technologies already implemented by Oracle, some of them require to be licensed separately, some not, to allow you to store, view and manage historical data.

Starting from Oracle 9i flashback version query technology can be used to get the previous version of a row - how data looked like before they got updated or deleted.

Oracle Workspace Manager allows you to version-enable tables to keep different versions of a row.

Starting from Oracle 11g, Total Recall technology(licensed separately) can be used to conveniently store, manage and view historical data.

Nick Krasnov
  • 26,886
  • 6
  • 61
  • 78
  • Thanks Nichilas,It's really helpful to get all available option for Audit.As we have more data customization on application side such as Display Old Value,New value,Created By ,Created Date,Organization search.I am really inrested to see how Oracle 11g Total Recall fit to our requirment. – user2819874 Sep 27 '13 at 12:26
  • Total Recall - since rebranded as Oracle Flashback Data Archive - is bundled free with all Oracle editions since 11.2.0.4. Which really makes rolling our own solution redundant. (Still need a license to compress FDA tables, but that is also true of BYO.) – APC Dec 29 '19 at 12:06