moving tablespace [message #196548] |
Thu, 05 October 2006 21:23 |
vintin
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 #196605 is a reply to message #196548] |
Fri, 06 October 2006 03:07 |
bwetkstr
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.
Kr
Karel.
|
|
|