Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Find out alternatives other than triggers to capture audit data

879119Jul 29 2011 — edited Oct 19 2011
Hi

I would like to know is there any alternate way to audit line level and insert/update/delete row level auditing mechanism other than trigger?

Instead of adding row before and row after trigger to capture audit information. Can we utilize sys table to do this ? My objective is not add more load (I/O) on DB.

Thanks
Sandeep
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 16 2011
Added on Jul 29 2011
8 comments
685 views