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@xxxxxxxxxxx] Sent: Friday, April 01, 2005 7:59 AM To: oracle-l@xxxxxxxxxxxxx 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/ -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l