Home » RDBMS Server » Server Administration » Temp Tablepace Reclaimation
icon6.gif  Temp Tablepace Reclaimation [message #191931] Fri, 08 September 2006 14:08 Go to next message
sjackson
Messages: 1
Registered: September 2006
Location: columbus
Junior Member
For Oracle 9i - Tablespace management in report database
I have a temp tsp extended to 80G. I understand that TSP's will not shrink back to origninal size without altering. Should I do manual shrinkage on a regular basis or is it fine to leave as is?

I have two main users groups. One uses primary uses canned reports and the other is dynamic. I have considered moving users to tsps based on this usage to better manage tsps?

Any prpoblems with this?

Thanks

Steven
Re: Temp Tablepace Reclaimation [message #191932 is a reply to message #191931] Fri, 08 September 2006 14:13 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please re-phrase.
What do you mean my TSP and TSPS here?
If somehow all would mean " temp tsp" which interpret as temporary tablespace, then all you need to do is
create a new temporary tablespace of you desired size.
Make it default to whole database.
Drop the old one.
>> I have considered moving users to tsps based on this usage to better manage tsps?
Please re-phrase.
You want allocate seperate temporary tablespaces or regular tablespaces?
Previous Topic: ADDM
Next Topic: partition key modification
Goto Forum:
  


Current Time: Sun Dec 04 08:42:46 CST 2016

Total time taken to generate the page: 0.12496 seconds