469,645 Members | 1,193 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,645 developers. It's quick & easy.

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
Jul 19 '05 #1
1 3130
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

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Bernhard Krautschneider | last post: by
8 posts views Thread by Jean-Marc Blaise | last post: by
4 posts views Thread by Civilian_Target | last post: by
14 posts views Thread by Ina Schmitz | last post: by
3 posts views Thread by Tejas | last post: by
9 posts views Thread by bluedolphin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.