Re: Q: discover Table-changes

Create a trigger to store the info in some kind of history table.

Amit
Oracle DBA/Unix SA

Arnd Empting wrote:

> Hi,
>
> Is there a way to determine, if a table has changed
> (insert/update/delete) and when was the last change?
>
> Currently we insert a timestamp in the tabel itself
> and test that timestamp, but this way we only cover
> insert and update. We dont see any changes through
> delete actions.
>
> I wonder if there's a more elegant way to determine
> the last change of a table?
>
> Arnd
Received on Wed Jan 21 1998 - 00:00:00 CST