Default Temporary tablespace in 9i

[julian]

Originally posted by virajvk
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

I see!

Then:

select property_value from database_properties 
where property_name = 'DEFAULT_TEMP_TABLESPACE';