MMCP,
The space in TEMP tablespace is not only used by your query. It will be used for all user's sort whose temporary tablespace is TEMP.

kbiswas,
For new threads, click "New Thread" link on top, not the "reply" link.

Sanjay