Re: Select only updated rows from a table

From: Pete <>
Date: Mon, 3 Mar 2008 15:09:06 -0800 (PST)
Message-ID: <>

On Mar 3, 4:25 pm, Robert Scheer <> wrote:
> Hi.
> The materialized views in Oracle have a log mechanism (the FAST
> clause) that can retrieve only the changed rows from a table. Is it
> possible to read this data in any way? I need to write a code that
> from time to time retrieves only the inserted/deleted/updated rows
> from a table and insert these rows on another table. I know that
> timestamp columns can be used for this, but is there any better
> solution to this?
> Regards,
> Robert Scheer

how about an after update trigger on the source table? you cannot query mv logs. Received on Mon Mar 03 2008 - 17:09:06 CST

Original text of this message