From oracle-l-bounce@freelists.org Thu Oct 27 00:59:04 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9R5x4Ro001434 for ; Thu, 27 Oct 2005 00:59:04 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j9R5x1vX001418 for ; Thu, 27 Oct 2005 00:59:01 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5ABCA211214; Thu, 27 Oct 2005 00:58:55 -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 02320-01; Thu, 27 Oct 2005 00:58:55 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AD973210CEB; Thu, 27 Oct 2005 00:58:54 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 27 Oct 2005 00:57:00 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0782A210208 for ; Thu, 27 Oct 2005 00:57:00 -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 01874-03 for ; Thu, 27 Oct 2005 00:56:59 -0500 (EST) Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.195]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D049C210159 for ; Thu, 27 Oct 2005 00:56:59 -0500 (EST) Received: by xproxy.gmail.com with SMTP id t11so506139wxc for ; Wed, 26 Oct 2005 22:56:59 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=a20ccdP3Q4Odow8xZB3NQn93lxRXvkvFVk3ZMgG7IvpbxxghGgVuwVrhLg7eaYNDZYJp/DOks1mUzIz3045ytJGCCcjZ2Aitw55lrvuBxVx8zzCLaSsfZIWbZoeDEiJnwLHbYtMeVEd3baWkwYXRDcDXYOMJH7hw2UjZm3P1Uig= Received: by 10.65.188.5 with SMTP id q5mr1353013qbp; Wed, 26 Oct 2005 22:56:59 -0700 (PDT) Received: by 10.64.149.6 with HTTP; Wed, 26 Oct 2005 22:56:59 -0700 (PDT) Message-ID: Date: Thu, 27 Oct 2005 07:56:59 +0200 From: Alex Gorbachev To: cmarquez@collegeboard.org Subject: Re: Dropping undo datafiles while db up Cc: oracle-l@freelists.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Content-Disposition: inline References: X-archive-position: 27663 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: gorbyx@gmail.com Precedence: normal Reply-To: gorbyx@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.9 required=5.0 tests=BAYES_00 autolearn=ham version=2.63 > >> replace an undo tablespace with another undo > >> tablespace while the instance is running. > > I gave similar advise but from old RBS perspective. > > But he actually and literary might just want to drop a single datafile > (rather than create a new)? > Which can not be done in <= 9i, but I see here in another post can be done > in 10G R2. Yep. The only way to do it in 9i is to switch UNDO tablespace to another one and recreate the old TS. One might need to wait up to retention_period time to drop this old UNDO TS though. -- Best regards, Alex Gorbachev -- http://www.freelists.org/webpage/oracle-l