Code:
SQL> select TEMPORARY_TABLESPACE from DBA_USERS where USERNAME = USER;

TEMPORARY_TABLESPACE
------------------------------
TEMP