RE: How move SYSTEM, TEMP and UNDOTBS1

From: Tirumala, Surendra (Education Cabinet) <Surendra.Tirumala_at_ky.gov>
Date: Fri, 1 Apr 2005 08:41:02 -0500
Message-ID: <063F65E6A14D0C47A5E9954B3C32354407E51F25@agency31.state.ky.us>

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 <file name>;' 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_at_hotmail.com] Sent: Friday, April 01, 2005 7:59 AM
To: oracle-l_at_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 Received on Fri Apr 01 2005 - 08:44:48 CST