Oracle触发器审计跟踪的替代解决方案 [英] Alternate Solution for Oracle Triggers for Audit Trail

问题描述

我们需要审核更改历史记录信息，其中包括捕获事务中的旧值和新值以进行更新和删除(旧值)操作.我已经在一个表上实现了触发器，但是随着表数量的增加，我不建议使用Oracle触发器选项. 谁能为审计变更历史记录提出更好的选择.

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.

推荐答案

Oracle已经实现了许多技术，其中有些需要单独获得许可，而有些则不需要，以允许您存储，查看和管理历史数据.

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.

从Oracle 9i开始闪回版本查询技术可用于获取行的先前版本-数据在更新或删除之前的外观.

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 允许您版本启用表以保留行的不同版本.

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

从Oracle 11g开始，总召回技术(单独许可)可用于方便地存储，管理和查看历史数据.

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

这篇关于Oracle触发器审计跟踪的替代解决方案的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！