Re: snapshot
From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Tue, 03 Feb 2004 21:50:36 +0100
Message-ID: <bvp0vc$ona$1_at_news2.tilbu1.nb.home.nl>
Date: Tue, 03 Feb 2004 21:50:36 +0100
Message-ID: <bvp0vc$ona$1_at_news2.tilbu1.nb.home.nl>
Ozy wrote:
> how to create a snapshot view on a table that refreshes each time a table is
> updated (or inserted row)?
> Or, at least, how to refresh snapshot periodicaly, let's say, each 10
> minutes?
>
> tnx
>
>
Versions would help, as refresh on commit did not work in 8i.
Look up the basic create materialized view command for every 10 minutes
-- Regards, Frank van BortelReceived on Tue Feb 03 2004 - 21:50:36 CET