| temp tablespace issue [message #53761] |
Wed, 09 October 2002 21:47  |
kshathrya
Messages: 29
Registered: October 2001
|
Junior Member |
|
|
how do i remove the space taken by temp tablespace. it has grown so fast ina days time and has consumed my full drive. please advice.
ks
|
|
|
|
| Re: temp tablespace issue [message #53770 is a reply to message #53761] |
Thu, 10 October 2002 07:21  |
Roy
Messages: 30
Registered: May 2002
|
Member |
|
|
|
One thing you can do is remove the table space and then recreate it pointing to a different drive. Or create a new mountpoint for a larger drive and use it for the temp.
|
|
|
|
| Re: temp tablespace issue [message #53772 is a reply to message #53761] |
Thu, 10 October 2002 08:48 |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
I believe you are using autoextend fuction. If you do not want the TS to grow in that manner, put a limit on the size, like 2 GB.
But before you can do that, you will have to drop tha TS, delete the data file and create a new TS with the limit.
Cheers.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
