From oracle-l-bounce@freelists.org Wed Mar 3 13:37:55 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i23Jbtq20340 for ; Wed, 3 Mar 2004 13:37:55 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i23Jbso20335 for ; Wed, 3 Mar 2004 13:37:54 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DAE64395359; Wed, 3 Mar 2004 14:37:20 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 03 Mar 2004 14:36:13 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from hero.affina.net (mailout.affina.com [12.20.72.25]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 86B9339534D for ; Wed, 3 Mar 2004 14:36:10 -0500 (EST) Received: by hero.affina.net with Internet Mail Service (5.5.2653.19) id ; Wed, 3 Mar 2004 13:40:02 -0600 Message-ID: <4A82CFCF30FDD211A7960008C7B19170236968AD@hero.affina.net> From: Chris Stephens To: oracle-l@freelists.org Subject: Problem with materialized view refresh... Date: Wed, 3 Mar 2004 13:39:51 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C40157.4B9BA2D0" X-archive-position: 227 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ChrisStephens@affina.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------_=_NextPart_001_01C40157.4B9BA2D0 Content-Type: text/plain We have a low transaction oltp here that we replicate via mv's to a reporting database. We have a refresh group set up to refresh all mv's every 2 hours. We have log tables on the base tables. The refresh type is 'force.' The refresh method is 'rowid.' At some point there was a row inserted into an employee table that was not propagated to the reporting database. I manually refreshed that mv via 'force/rowid' and still the row did not appear in reporting database. When I changed the refresh type to complete, it appeared. This is scary as hell to me and has me thinking that our method is severely flawed somehow...i.e. I didn't RTFM close enough. Is this expected behavior? HP-UX 8.1.7.2 Thanks ------_=_NextPart_001_01C40157.4B9BA2D0 Content-Type: text/html

We have a low transaction oltp here that we replicate via mv's to a reporting database.

We have a refresh group set up to refresh all mv's every 2 hours.

We have log tables on the base tables. The refresh type is 'force.' The refresh method is 'rowid.'

At some point there was a row inserted into an employee table that was not propagated to the reporting database.

I manually refreshed that mv via 'force/rowid' and still the row did not appear in reporting database.

When I changed the refresh type to complete, it appeared.

This is scary as hell to me and has me thinking that our method is severely flawed somehow...i.e. I didn't RTFM close enough.

Is this expected behavior?

HP-UX 8.1.7.2

Thanks

------_=_NextPart_001_01C40157.4B9BA2D0-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------