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