| Can you truncate TEMPDB tablespace? [message #452049] |
Mon, 19 April 2010 13:14  |
playitsafe
Messages: 19
Registered: January 2009
Location: NJ
|
Junior Member |
|
|
I have an application that fills up my TEMPDB space. I'm upgrading to 10.1.0.5 on Wed night, this will eliminate the bug.
My question is 2 part:
1) When I upgrade to 10.1.0.5, will that truncate the space? If not, how can I do that?
2) Also, i have a very large TEMPDB space from expanding it so many times. What is best way to reduce the size of this tablespace once it is cleared?
Thank you
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Can you truncate TEMPDB tablespace? [message #453597 is a reply to message #452049] |
Thu, 29 April 2010 18:40  |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
playitsafe wrote on Mon, 19 April 2010 14:14I have an application that fills up my TEMPDB space. I'm upgrading to 10.1.0.5 on Wed night, this will eliminate the bug.
My question is 2 part:
1) When I upgrade to 10.1.0.5, will that truncate the space? If not, how can I do that?
2) Also, i have a very large TEMPDB space from expanding it so many times. What is best way to reduce the size of this tablespace once it is cleared?
Thank you
1. No.It will not truncate the TEMPDB space.
2. Drop that TEMPDB and create another one.
--
Sanjay
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
