For performance reasons the data changes are audited on the record-level rather then column-level. It is much much faster. That's why every time you make a change the entire record is saved in the audit trail using just a singe copy operation. If you want to see only the changed values on the report you can create your custom reports that shows such changes.
: We are experimenting with DB Audit on an Oracle 8i
: system. Selected a few tables and selected columns
: to audit updates only. However the result tables
: often show all the data as the same before and after.
: If we audit the same tables but audit *all* the columns,
: then we usually see data change in one of the columns. : The data change is occuring by use of a third-party
: application not developed in-house. Am I right in
: suspecting that the developer chose to do the updates
: in such a way as to update the entire row instead of
: just the changed fields? : Thanks
|
