Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie question re refreshing Materialized Views
> From my reading of both 9i's and 10g's coverage of atomic_refresh, the
> "atomicity" (misuse of that word, but you get my drift, maybe) of the
> operation is that the list of views are refreshed as an atom, not that the
> refresh process itself is handled as an atom. Am I reading it wrong?
Actually to be frank I've not read docs completely about this very
problem, I've just experienced certain behaviour :)
This behaviour also can be approved tracing the refreshes and looking
what exactly Oracle does.
For more info you can also check this asktom thread
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:15695764787749
Gints Plivna
http://www.gplivna.eu
Received on Thu Aug 16 2007 - 08:18:56 CDT