which tablespace as been assiged as temp

[Former Member]

Hi all,

I wanted to know the sql statement through which I can confirm which tablespace has been currently used for temp.

Is it system tablespace or temp table space.

Kindly tell me the query.

Rgds

Lalit Ran

[stefan_koehler]

Hello,

and if you want to identify the default temp tablespace for your database (it is used when no temp tablespace is specified in the create user statement).

> SQL> SELECT * FROM DATABASE_PROPERTIES where PROPERTY_NAME='DEFAULT_TEMP_TABLESPACE';

Regards

Stefan

[Former Member]

Differrent users may have different temporary tablespaces;

select username, temporary_tablespace from dba_users