OraFAQ Forum: Server Administration » Can you truncate TEMPDB tablespace?

Home » RDBMS Server » Server Administration » Can you truncate TEMPDB tablespace? (10.1.0.2 Windows Server )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: Can you truncate TEMPDB tablespace? [message #452051 is a reply to message #452049]

Mon, 19 April 2010 13:16

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What is your TEMPDB space, exactly?

Regards
Michel

Report message to a moderator

Re: Can you truncate TEMPDB tablespace? [message #452052 is a reply to message #452049]

Mon, 19 April 2010 13:22

playitsafe
Messages: 19
Registered: January 2009
Location: NJ

Junior Member

My user DB's total 3gig, my TEMP database is 75gig. It will need to be reduced back to 33G once the upgrade happens.

Report message to a moderator

Re: Can you truncate TEMPDB tablespace? [message #452053 is a reply to message #452052]

Mon, 19 April 2010 13:34

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If it is in use, create a new temp tablespace, assign the users to it, move the GTT to it, restart the database and drop the previous temp tablespace.

Regards
Michel

Report message to a moderator

Re: Can you truncate TEMPDB tablespace? [message #452054 is a reply to message #452053]

Mon, 19 April 2010 13:42

playitsafe
Messages: 19
Registered: January 2009
Location: NJ

Junior Member

GTT ?

Report message to a moderator

Re: Can you truncate TEMPDB tablespace? [message #452055 is a reply to message #452054]

Mon, 19 April 2010 13:49

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Global Temporary Table, maybe you have none.

Regards
Michel

Report message to a moderator

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:14

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

1. No.It will not truncate the TEMPDB space.
2. Drop that TEMPDB and create another one.
--
Sanjay

Report message to a moderator

Re: Can you truncate TEMPDB tablespace? [message #453609 is a reply to message #453597]

Thu, 29 April 2010 23:54

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Which still does not add anything to an old topic.
Why do you waste your time to post in old and already answered topic?

Regards
Michel

Report message to a moderator

Previous Topic:	File format of dbf files (merged)
Next Topic:	The aim of WMSYS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 20:32:16 CDT 2025