Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Data auditing: triggers vs application code
I would suggest looking into Oracle Workspace Manager as Option #3.
There are some annoyances particularly in 9i about different things that don't quite work with version-enabled tables (you can't have non-primary unique constraints until 10.1 for example) but if it works for you, it's quite slick.
Application Developer's Guide - Workspace Manager
http://download-west.oracle.com/docs/cd/B14117_01/appdev.101/b10824/toc. htm
Justin Cave
Distributed Database Consulting, Inc.
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sandeep Dubey
Sent: Wednesday, September 21, 2005 3:52 PM
To: oracle-l
Subject: Data auditing: triggers vs application code
Hi,
I need to keep track of history of data change in the live tables. Two methods are being compared.
The cons against using triggers in the order of severity are:
As a database person, I am inclined to use triggers. But I fail to guarantee that trigger will never get disabled. If it is disabled somehow application SHOULD stop. (It is impractical to check the status of all underlying triggers before each transaction).
I would like to hear how you guys handle data auditing in your system.
Thanks
Sandeep
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 21 2005 - 18:58:25 CDT
![]() |
![]() |