Re: Question on "temp" tablespace

From: Steve Butler <sbut-is_at_seatimes.com>
Date: 1995/04/13
Message-ID: <Pine.SUN.3.91.950413080438.29537A-100000_at_seatimes>#1/1


On 12 Apr 1995, Systems Engineering wrote:
> 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"?

Nope. When you do a CREATE USER you define the TEMP and DEFAULT tablespaces for that user. The tablespace you assign as being the temporary tablespace is used. This could be different for each user. That would be a nightmare to administer.

--Steve

+----------------------------------------------------+
| Steve Butler          Voice:  206-464-2998         |
| The Seattle Times       Fax:  206-382-8898         |
| PO Box 70          Internet:  sbut-is_at_seatimes.com |
| Seattle, WA 98111    Packet:  KG7JE_at_N6EQZ.WA       |
+----------------------------------------------------+
All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Thu Apr 13 1995 - 00:00:00 CEST

Original text of this message