Home » RDBMS Server » Server Administration » moving tablespace
moving tablespace [message #196548] Thu, 05 October 2006 21:23 Go to next message
Messages: 1
Registered: October 2006
Junior Member
Hello, I am running Oracle 10g Release 1 on Windows 2000 server.

My C drive is running out of space and I would like to move the temp tablespace which keeps getting bigger to another drive and delete the existing one. Is this possible? Thnx for any suggestions.
Re: moving tablespace [message #196553 is a reply to message #196548] Thu, 05 October 2006 21:34 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10673
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
create a new one whereever you want.
Make it default.
Drop the old the one.
Re: moving tablespace [message #196605 is a reply to message #196548] Fri, 06 October 2006 03:07 Go to previous message
Messages: 114
Registered: August 2005
Senior Member
you could also add a datafile located at the new location and then delete the old datafile of the temp tablespace.

I find this better because user sometimes don't have the value 'default' as temp tablespace, sometimes the real name of the temp tablespace is used. And in this case you don't need to check that.

Previous Topic: dba_jobs_running, sql navigator.
Next Topic: Unable to access EM using web browser
Goto Forum:

Current Time: Fri Jul 21 12:15:09 CDT 2017

Total time taken to generate the page: 0.07335 seconds