Re: Question on "temp" tablespace

-- 
In article <1995Apr12.070940.1905_at_biivax.dp.beckman.com>, Systems Engineering <rdd_at_nexus.aer.loral.com> writes:


::Newsgroups: comp.databases.oracle

::Subject: Question on "temp" tablespace

::From: Systems Engineering <rdd_at_nexus.aer.loral.com>

::

::It is not obvious to me how the "temp" tablespace is identified as a 


::"special" tablespace to use for sorting, etc. In other words, what

::in Oracle directs processes to use the temporary tablespace?

::

::Is it just the name "temp"?

::

::Thanks for any help.

::


 The Temporary Tablesspace (and Default) are determined on a per user basis
 The name is site dependant and there could be more than one tablespace
 used for the Temporary Tablespace.  
 
  SQL> select temporary_tablespace,DEFAULT_TABLESPACE
    2  from user_users;

  TEMPORARY_TABLESPACE           DEFAULT_TABLESPACE
  ------------------------------ ------------------------------
  RADMIS_TEMP                    RADMIS_MAIN


 These are maintained with CREATE USER/ALTER USER

 Hope this helps.

  
+--------------------------+-------------------------+-----------------------+
| Ian Bainbridge           | bainbridge.i_at_bgers.co.uk|Phone: (44)191-216-0202|
| British Gas ERS          | Newcastle Upon Tyne, UK |            x2790      |
+--------------------------+-------------------------+-----------------------+