Re: Question on "temp" tablespace

From: Jim Gregory <Jim.Gregory_at_daytonoh.attgis.com>
Date: 1995/04/14
Message-ID: <D71J7y.3x3_at_corsair.daytonoh.attgis.com>#1/1


>==========Systems Engineering, 4/12/95==========
>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
i>n Oracle directs processes to use the temporary tablespace?

>Is it just the name "temp"?
 

>Thanks for any help.

You use the "Temporary Tablespace <ts_name> clause in the create/alter user command to assign a user to the TEMP TS for sorting, etc. Otherwise, ORACLE will will do all such activity for the user in the SYSTEM TS. Actually, you can name the TEMP TS anything you want as long as you use the clause above to point the user to it. TEMP is just the standard, meaningful, name for a TS for this activity.

Hope this explains it - Jim Gregory Received on Fri Apr 14 1995 - 00:00:00 CEST

Original text of this message