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]


Oracle LazyDBA home page