用于审计跟踪的 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屋！