Re: Tracking changes

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 20 Sep 2003 04:58:31 -0700
Message-ID: <1a75df45.0309200358.4b5e8e9c@posting.google.com>

ferraroj <member40432_at_dbforums.com> wrote

> I would like to be able to monitor changes to data within a number of
> tables. I would prefer to have a routine that was generic and did not
> rely on the structure of the table. I was thinking of having a "before
> update trigger" call the routine. Below is an idea of the type of code
> I'm trying to create

<snipped>

Bad Idea. As Daniel mentioned - performance.

Two words.

Audit.

History.

Don't confuse the two. You do not "track changes", i.e. auditing. in Oracle with triggers.

--
Billy

Received on Sat Sep 20 2003 - 06:58:31 CDT