From: "Christian Antognini" Newsgroups: comp.databases.oracle.server References: <8b51k0p37eqddbta8bp77sstjb1unie0sm@4ax.com> Subject: Re: Materialized View - Transactional Refreshing Date: Thu, 9 Sep 2004 21:46:37 +0200 Lines: 34 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 NNTP-Posting-Host: 62.48.119.54 X-Original-NNTP-Posting-Host: 62.48.119.54 Message-ID: <4140b319$1@post.usenet.com> X-Trace: post.usenet.com 1094759193 62.48.119.54 (9 Sep 2004 14:46:33 -0500) Organization: Usenet.com http://www.usenet.com 100,000+ UNCENSORED Newsgroups. The #1 Usenet Service on the Planet! X-Comments: This message was posted through Usenet.com's, FREE publicly accessible Usenet Server - "post.usenet.com" X-Comments2: IMPORTANT: Usenet.com does not condone, nor support, spam or any illegal or copyrighted postings. X-Comments3: IMPORTANT: Under NO circumstances will postings containing illegal or copyrighted material through this service be tolerated!! X-Report: Please report illegal or inappropriate use to X-Abuse-Info: Please be sure to forward a copy of ALL headers, INCLUDING the body (DO NOT SEND ATTACHMENTS) Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!news-out2.nntp.be!local!post.usenet.com!not-for-mail Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:224612 **** Post for FREE via your newsreader at post.usenet.com **** "Sybrand Bakker" wrote in message news:8b51k0p37eqddbta8bp77sstjb1unie0sm@4ax.com... > On Thu, 09 Sep 2004 10:50:30 -0400, Peter Sylvester > wrote: > > >Is there a way to get Oracle to make this transactional (using a delete > >statement), so the mview will always be usable? > > no. Nor does your suggestion make sense because the mview would be > locked during the delete, and delete compared to truncate is pretty > inefficient. > But if you think a home-grown 'solution' will address your needs, why > don't you go ahead knowing better? Hi Sybrand Sorry, but the correct answer is yes. In fact to avoid the TRUNCATE the mview can be added into a refresh group. Excerpt from the Oracle9i Advanced Replication guide (http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96567/reptrou ble.htm#8549): "Complete refreshes of a single materialized view internally use the TRUNCATE feature to increase speed and reduce rollback segment requirements. However, until the materialized view refresh is complete, users may temporarily see no data in the materialized view. Refreshes of multiple materialized views (for example, refresh groups) do not use the TRUNCATE feature." Chris -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=