From oracle-l-bounce@freelists.org Fri Apr 1 08:44:48 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j31EimCB001556 for ; Fri, 1 Apr 2005 08:44:48 -0600 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 j31Eimem001545 for ; Fri, 1 Apr 2005 08:44:48 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AC0708B22C; Fri, 1 Apr 2005 08:42:48 -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 10350-03; Fri, 1 Apr 2005 08:42:48 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 244448B139; Fri, 1 Apr 2005 08:42:48 -0500 (EST) Message-ID: <063F65E6A14D0C47A5E9954B3C32354407E51F25@agency31.state.ky.us> From: "Tirumala, Surendra (Education Cabinet)" To: "'cemail_219@hotmail.com'" Cc: oracle-l@freelists.org Subject: RE: How move SYSTEM, TEMP and UNDOTBS1 Date: Fri, 1 Apr 2005 08:41:02 -0500 MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-archive-position: 17965 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Surendra.Tirumala@ky.gov Precedence: normal Reply-To: Surendra.Tirumala@ky.gov X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.1 required=5.0 tests=AWL autolearn=ham version=2.60 X-Spam-Level: I am sure you are asking about how to move these TSs while db is up and running..but it is not possible... My only option would be: 1) Shutdown the db 2) move(cp could be safe thing to do, so that files at source locations will also be retained, just in case) the datafiles associated with SYSTEM and UNDOTBS1 tablespaces to new mount points 3) Startup db mount 4) issue 'alter database datafile rename ;' for all the above datafiles. 5) drop and recreate TEMP ts 6) alter database open Thanks, Surendra Tirumala -----Original Message----- From: J. Dex [mailto:cemail_219@hotmail.com] Sent: Friday, April 01, 2005 7:59 AM To: oracle-l@freelists.org Subject: How move SYSTEM, TEMP and UNDOTBS1 How do you move the SYSTEM, TEMP and UNDOTBS1 from one mount point to another? I was able to move other tablespaces/datafiles but cannot take those offline. Thanks. _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l