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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie question re refreshing Materialized Views

Re: Newbie question re refreshing Materialized Views

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Thu, 16 Aug 2007 06:18:56 -0700
Message-ID: <1187270336.804990.195460@19g2000hsx.googlegroups.com>


> 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

Original text of this message

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