Temporary files cannot shrink at runtime: they are only deleted when the associated database is stopped.
Are you looking for how to avoid large temp files to begin with?
answered 25 Apr '13, 10:28
You cannot shrink the temporary file without bouncing the database.
IMO there is no technical reason to do so... there are technical reasons why you might not want the temporary file to grow in the first place, but if those reasons don't apply, then leave well enough alone.
There may be emotional reasons to shrink the temporary file ... but ... emotions ... are ... illogical ... :)
answered 26 Apr '13, 05:54