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
|