Re: Q: discover Table-changes

In article <34C3376F.2409324C_at_in-gmbh.de>, Arnd Empting wrote: Look at Oracle AUDITING.

You can determine everything that happens to a table, including select's.

Of course, there is some overhead as you generate additional SQL when you insert into SYS.AUD$

regs

Neil Chandler

>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 Mon Jan 19 1998 - 00:00:00 CST