Perhaps a dumb question, but why do you want to shrink it? It'll have to
reallocate extents next time a large sort runs, which will slow performance
(though I can quantify how much w/o testing on your system).

-----Original Message-----
From: Wu Ji-Ye (TSG-GDCC-SH)
[mailto:oracledba-ezmlmshield-x87030658.[Email address protected]
Sent: Thursday, April 07, 2005 2:18 AM
To: LazyDBA Discussion
Subject: shrink the temporary tablespace



Hi,

Does anybody know how to shrink the temporary tablespace? It seems that
oracle will not automatically release the space after a long sort
transcation.

I always use the following steps to deal with this problem.

1. create a new temporary tablespace named temp2
2. switch users to temp2 tablespace
3. drop the old temporary tablespace named temp to release the space.
4. recreate the temp tablespace
5. switch users to the temp tablespace.
6. drop the temp2 tablespace.

Jonathan
HP Global Delivery China Center (GDCC)
Tel: 86 21 2898-3106
Fax: 86 21 2898-2112
Email: ji-ye.[Email address protected]



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
**************************************************************************************
The information contained in this email is privileged and confidential information intended only for the use of the individual or entity named as recipient. If the reader is not the intended recipient, please be notified that any dissemination, distribution, or copy of this communication is strictly prohibited. If you have received this communication in error, please do not disclose this communication to any other person. Please notify us immediately by telephone and return the original to us at the address indicated above. Thank you

Oracle LazyDBA home page