Table data auditing / triggers

Hi All,

I'm looking for suggestions as to how best to implement table data modification auditing. I have 100+ tables in which I would like capture the after record image of any insert and update on each table.

I assume that I'll need to create an audit table for each data table and create an AFTER UPDATE OR INSERT trigger to insert the :new values for all columns into the corresponding audit table.

I was hoping to avoid creating 100+ audit tables and corresponding triggers especially if Oracle already has a equivalent built-in feature. At the very least, I was looking for a way to avoid hand-coding the audit table and trigger creation.

I would appreciate any thoughts you may have.

TIA,
Allan Received on Tue Sep 07 1999 - 14:02:16 CDT