Um his very first reply tells you how to set the users temporary tablespace. The tablespace you specify there is used for sorting.