What do mean by shrink? Resize the datafile or free up space?

Si

-----Original Message-----
From: Wu Ji-Ye (TSG-GDCC-SH)
[mailto:oracledba-ezmlmshield-x87030658.[Email address protected]
Sent: Thursday, April 07, 2005 7: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


Oracle LazyDBA home page