Default Temporary tablespace in 9i

dear sir ,

In oracle 9i we can have multiple temporary tablespace and one default temporary tablespace for database.

Say I have 5 temporary tablespaces I can switch between them to make any one of them default for that database.

I just want to know from which of data dictionary view I can get information about current temporary tablespaces.


bye
virajvk

Hi,

DBA_TABLESPACES.
DBA_TEMP_FILES.

Vijay.

Sorry sir ,

My question how to find at any point of time which is my default temporary tablespace for database (not for any particular user).

Here I am talking about the new 9i feature of temporary tablespace.

Dictionary views which u have suggested do not give me requried information

virajvk

hey all 9i DBAs
Is There any way we can find this one ???
viraj

Code:

---

SQL> select TEMPORARY_TABLESPACE from DBA_USERS where USERNAME = USER;

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

---

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

Quote:

---

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:

Code:

---

select property_value from database_properties
where property_name = 'DEFAULT_TEMP_TABLESPACE';

---

thanks julian

You r always brilliant.


virajvk

Hi.

SQL> select * from database_properties where property_name = 'DEFAULT_TEMP_TABLESPACE';

PROPERTY_NAME
------------------------------
PROPERTY_VALUE
----------------------------------------------------------------------------------------------------
DESCRIPTION
----------------------------------------------------------------------------------------------------
DEFAULT_TEMP_TABLESPACE
TEMP
Name of default temporary tablespace


1 row selected.

SQL>

Cheers