Re: How to tell if a row has been updated?

From: Arnold Schommer <aschommer_at_fs-edv.de>
Date: Mon, 21 Dec 1998 14:42:37 +0100
Message-ID: <367E504D.2B8E040@fs-edv.de>

Jofre Family wrote:
>
> Is there a way, I can find out whether a row in a particular table has
> been
> updated, deleted, inserted from the last time I scanned its contents
> within any of the ORACLE system tables (V$*)?
>
> I am working on an auto load process, and I would like to load a
> secondary DB with only the changes that have occurred to a particular
> table (incremental loads).
>
> Any sugestions would be greatly appreciated. Either post your answers
> here or email me at;
> carfre_at_hotmail.com
>
> Cheers!
>
> CJ

What about row-level triggers ?
E.g.

	CREATE OR REPLACE example
	BEFORE UPDATE OF EMPNO ON EMP
	FOR EACH ROW
	...

(for scorr/tiger)

hope it helps

Arnold Schommer Received on Mon Dec 21 1998 - 07:42:37 CST