Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: snapshot

Re: snapshot

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Tue, 03 Feb 2004 21:50:36 +0100
Message-ID: <bvp0vc$ona$1@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 Bortel
Received on Tue Feb 03 2004 - 14:50:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US