Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Q: discover Table-changes
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