SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Data Change-Nothing Changed?

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Data Change-Nothing Changed?
Author Message
Glen



Joined: 28 Jul 2005
Posts: 1

Post Data Change-Nothing Changed? Reply with quote

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

Thu Jul 28, 2005 4:56 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Re: Data Change-Nothing Changed? Reply with quote

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

Thu Jul 28, 2005 6:09 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.