From oracle-l-bounce@freelists.org Mon Sep 27 23:57:55 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i8S4vt311473 for ; Mon, 27 Sep 2004 23:57:55 -0500 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 i8S4vtI11468 for ; Mon, 27 Sep 2004 23:57:55 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E0FD972C2CF; Tue, 28 Sep 2004 00:03:57 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15440-78; Tue, 28 Sep 2004 00:03:57 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 53CBF72C124; Tue, 28 Sep 2004 00:03:57 -0500 (EST) Message-ID: <20040928050224.51071.qmail@web54206.mail.yahoo.com> Date: Mon, 27 Sep 2004 22:02:24 -0700 (PDT) From: Rivaldi Bahar Subject: Temp segment Pctincrease 1 To: oracle-l@freelists.org In-Reply-To: <492F4322B62F3C4CBA5131524867C8E40206A4@ussunex1.palmsource.com> MIME-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 10241 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: rbahar99@yahoo.com Precedence: normal Reply-To: rbahar99@yahoo.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org What is the similar statement for 'alter tablespace temp default storage (pctincrease 1)' for Oracke 9.2 ? It worked for Oracle 8.1 to coalesce temporary tablespace. Thanks. --------------------------------- Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! -- http://www.freelists.org/webpage/oracle-l