From oracle-l-bounce@freelists.org Wed Oct 26 16:57:28 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9QLvSds022327 for ; Wed, 26 Oct 2005 16:57:28 -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 j9QLvOvX022313 for ; Wed, 26 Oct 2005 16:57:24 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EB2F6210CE5; Wed, 26 Oct 2005 16:57:18 -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 17075-09; Wed, 26 Oct 2005 16:57:18 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6A74121090B; Wed, 26 Oct 2005 16:57:18 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 26 Oct 2005 16:55:23 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 87EA321085C for ; Wed, 26 Oct 2005 16:55:23 -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 16731-02 for ; Wed, 26 Oct 2005 16:55:23 -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 5E22121083C for ; Wed, 26 Oct 2005 16:55:23 -0500 (EST) Received: by xproxy.gmail.com with SMTP id s7so493180wxc for ; Wed, 26 Oct 2005 14:55:23 -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=oc+4PFqPqmUq7dGjJNBDYFibFThFsYSnxms0J+bHkj68h24iAMPSlPe8O9xk8LhpwIjUCzphCjsSCm2W9SHTVPahlGUIF1uhhGNloRVB+VMBKSsqNSJpzSNUNbVma7lcDp/NOx3kZzgc7Q8JNQtRb83JBjp+oFI3/UtXHrOkXLI= Received: by 10.64.210.13 with SMTP id i13mr1090378qbg; Wed, 26 Oct 2005 14:55:23 -0700 (PDT) Received: by 10.64.149.6 with HTTP; Wed, 26 Oct 2005 14:55:22 -0700 (PDT) Message-ID: Date: Wed, 26 Oct 2005 23:55:22 +0200 From: Alex Gorbachev To: cemail_219@hotmail.com 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: 27649 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 What's wrong with old good RTFM first? This is for 10g: http://oraclelon1.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams222.htm#sthref897 "UNDO_TABLESPACE specifies the undo tablespace to be used when an instance starts up. If this parameter is specified when the instance is in manual undo management mode, then an error will occur and startup will fail. If the UNDO_TABLESPACE parameter is omitted, the first available undo tablespace in the database is chosen. If no undo tablespace is available, the instance will start without an undo tablespace. In such cases, user transactions will be executed using the SYSTEM rollback segment. You should avoid running in this mode under normal circumstances. You can replace an undo tablespace with another undo tablespace while the instance is running." 2005/10/26, J. Dex : > Is there anyway to drop datafiles from an undo tablespace while the database > is up (running in noarchivelog mode)? Or, do you have to startup nomount > and alter database drop datafile? > > _________________________________________________________________ > Don't just search. Find. Check out the new MSN Search! > http://search.msn.click-url.com/go/onm00200636ave/direct/01/ > > -- > http://www.freelists.org/webpage/oracle-l > > > -- Best regards, Alex Gorbachev -- http://www.freelists.org/webpage/oracle-l