Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id gBJIDYC09411 for ; Thu, 19 Dec 2002 12:13:34 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id gBJIDX309405 for ; Thu, 19 Dec 2002 12:13:33 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id GAA67326; Thu, 19 Dec 2002 06:56:15 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0051E194; Thu, 19 Dec 2002 06:34:24 -0800 Message-ID: Date: Thu, 19 Dec 2002 06:34:24 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: =?iso-8859-1?q?Stephane=20Paquette?= Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: =?iso-8859-1?q?Stephane=20Paquette?= Subject: problems with materialized view Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi, On Oracle 8.1.7.2 /aix 4.3 Refreshing complete a MV took forever, I canceled them after 10 hours. Dropping and recreating it took 10 minutes. On another MV, refreshing complete uses over 1G temp space, when dropping and recreating no temp tablespace busting. On smaller ones no difference between drop/create and refresh. The ones I've got problems with have query over 3 pages long. Oracle bugs ? ===== Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant stephane_paquette@yahoo.com __________________________________________________________ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: stephane_paquette@yahoo.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).