From oracle-l-bounce@freelists.org Fri Apr 1 09:34:27 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j31FYOZH010077 for ; Fri, 1 Apr 2005 09:34:25 -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 j31FYOem010063 for ; Fri, 1 Apr 2005 09:34:24 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0C09F8B0AB; Fri, 1 Apr 2005 09:32:21 -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 27844-09; Fri, 1 Apr 2005 09:32:20 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 860AA8B090; Fri, 1 Apr 2005 09:32:20 -0500 (EST) Message-ID: <063F65E6A14D0C47A5E9954B3C32354407E51F27@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 09:21:31 -0500 MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-archive-position: 17971 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: Proper syntax for rename datafile is .. ALTER DATABASE RENAME FILE '/u11/oradata/DESCMS/xxxxx.dbf' TO '/u10/oradata/DESCMS/xxxxx.dbf'; -----Original Message----- From: Tirumala, Surendra (Education Cabinet) [mailto:Surendra.Tirumala@ky.gov] Sent: Friday, April 01, 2005 8:41 AM To: 'cemail_219@hotmail.com' Cc: oracle-l@freelists.org Subject: RE: How move SYSTEM, TEMP and UNDOTBS1 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 -- http://www.freelists.org/webpage/oracle-l