Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

Has anyone successfully used the TARGET_COLMAP$ column in Oracle Change Data Control to identify which columns have changed? I'm trying to produce audit reports for users and identify for the user what has changed, to save them scanning the before and after column values in an update operation. COLMAP$ looks like a perfect mechanism, but it seems unreliable. Any folks have any experience?

share|improve this question
Does it determine what has changed by looking at the columns affected by the DML used in the operation, or by actually looking at the before and after values of the fields? – Steve Sep 7 '12 at 9:46

migrated from stackoverflow.com Sep 9 '12 at 22:25

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.