Path: text.usenetserver.com!out02a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!19g2000hsx.googlegroups.com!not-for-mail From: Gints Plivna Newsgroups: comp.databases.oracle.misc Subject: Re: Newbie question re refreshing Materialized Views Date: Thu, 16 Aug 2007 06:18:56 -0700 Organization: http://groups.google.com Lines: 15 Message-ID: <1187270336.804990.195460@19g2000hsx.googlegroups.com> References: <1eabs7v6ibs54.1js9c40tduddv.dlg@40tude.net> <1187209800.580748.158710@r29g2000hsg.googlegroups.com> NNTP-Posting-Host: 91.190.33.82 Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Trace: posting.google.com 1187270337 11473 127.0.0.1 (16 Aug 2007 13:18:57 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Thu, 16 Aug 2007 13:18:57 +0000 (UTC) In-Reply-To: User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe) X-HTTP-Via: 1.0 ISA Complaints-To: groups-abuse@google.com Injection-Info: 19g2000hsx.googlegroups.com; posting-host=91.190.33.82; posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0 Xref: usenetserver.com comp.databases.oracle.misc:249330 X-Received-Date: Thu, 16 Aug 2007 09:18:57 EDT (text.usenetserver.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