dear julian

What query u have suggested is for only that user.

I want to know default temporary tablespace of my database at any point of time since Oracle 9i gives me flexiblity of changing default temporary tablespace of database.

Please guide me if I am going on wrong track in above default temporary tablespace fundamentals

virajvk