Path: text.usenetserver.com!out02b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!e23g2000prf.googlegroups.com!not-for-mail From: Robert Scheer Newsgroups: comp.databases.oracle.server Subject: Select only updated rows from a table Date: Mon, 3 Mar 2008 13:25:19 -0800 (PST) Organization: http://groups.google.com Lines: 12 Message-ID: NNTP-Posting-Host: 200.155.29.76 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Trace: posting.google.com 1204579519 8695 127.0.0.1 (3 Mar 2008 21:25:19 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Mon, 3 Mar 2008 21:25:19 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: e23g2000prf.googlegroups.com; posting-host=200.155.29.76; posting-account=xEgn3QkAAAAGMYlY2VjJxHED06n-S7UM User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648),gzip(gfe),gzip(gfe) X-HTTP-Via: 1.1 wsmzproxy.wilsonsons.com.br (squid/3.0.STABLE1) Xref: usenetserver.com comp.databases.oracle.server:442079 X-Received-Date: Mon, 03 Mar 2008 16:25:19 EST (text.usenetserver.com) 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