Default Temporary tablespace in 9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Default Temporary tablespace in 9i

Hybrid View

  1. #1
    Join Date
    Jan 2002
    Location
    India
    Posts
    105

    Arrow

    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 !!!

  2. #2
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    DBA_TABLESPACES.
    DBA_TEMP_FILES.

    Vijay.
    Say No To Plastics

  3. #3
    Join Date
    Jan 2002
    Location
    India
    Posts
    105

    Arrow

    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 !!!

  4. #4
    Join Date
    Jan 2002
    Location
    India
    Posts
    105
    hey all 9i DBAs
    Is There any way we can find this one ???
    viraj
    A Wise Man Knows How much he doesn't know !!!

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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
    email: ocp_9i@yahoo.com

  6. #6
    Join Date
    Jan 2002
    Location
    India
    Posts
    105
    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 !!!

  7. #7
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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
    email: ocp_9i@yahoo.com

  8. #8
    Join Date
    Jan 2002
    Location
    India
    Posts
    105
    thanks julian

    You r always brilliant.


    virajvk
    A Wise Man Knows How much he doesn't know !!!

  9. #9
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    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
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width