Originally posted by Ablakios
I can manually deallocate when need be and when there is no sorting going on since I cannot afford to shutdown the database every time I have full temp tablespace issue.
Just trying to understand here...
You deallocate TEMP space at one point just to have the users use it again sometime later?