Select only updated rows from a table

From: Robert Scheer <>
Date: Mon, 3 Mar 2008 13:25:19 -0800 (PST)
Message-ID: <>


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?

Robert Scheer Received on Mon Mar 03 2008 - 15:25:19 CST

Original text of this message