snapshot

[Ozy]

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

[Frank van Bortel]

Re: snapshot

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