-
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
A Wise Man Knows How much he doesn't know !!!
-
Hi,
DBA_TABLESPACES.
DBA_TEMP_FILES.
Vijay.
Say No To Plastics
-
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
A Wise Man Knows How much he doesn't know !!!
-
hey all 9i DBAs
Is There any way we can find this one ???
viraj
A Wise Man Knows How much he doesn't know !!!
-
Code:
SQL> select TEMPORARY_TABLESPACE from DBA_USERS where USERNAME = USER;
TEMPORARY_TABLESPACE
------------------------------
TEMP
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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
A Wise Man Knows How much he doesn't know !!!
-
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';
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
thanks julian
You r always brilliant.
virajvk
A Wise Man Knows How much he doesn't know !!!
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|