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

Report message to a moderator

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: 10708
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?

Report message to a moderator

Previous Topic: ADDM
Next Topic: partition key modification
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Feb 21 12:42:54 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.