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: Magnus Bengtsson <magnus.bengtsson_at_imentum.se>
Date: Thu, 16 Aug 2007 14:14:02 +0200
Message-ID: <5iitclF3p3f83U1@mid.individual.net>

> 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?

Apparently someone reported a bug which caused the behaviour to change between 9i and 10g. See Metalink notes 365157.1 and 3168840.8.

But it seems the documentation has not been updated.

> If the atomic_refresh option means "handle the refresh itself as an atom",
> then this is exactly what I want.

In 10g it means that.
In 9i the refresh is not atomic.

/Magnus Received on Thu Aug 16 2007 - 07:14:02 CDT

Original text of this message

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