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