Re: Temporary table

From: Paul Smith <psmith_at_sprynet.co.uk>
Date: 1996/07/15
Message-ID: <4scmq9$7ll_at_lore.interserv.net>#1/1


> joebrown_at_southeast.net writes:
> jtdennis_at_atl.mindspring.com (John Dennis) wrote:
>
> >Nope. This is one my list of top-ten things I wish Oracle had that
> >Sybase does. The opposite list is quite long so don't thing I'm a
> >Sybaser. Anyway, no temp tables.
>
> If this is true, what is the Temporary_data tablespace used for?
>
> (I'm ignorant, not intentionally sarcastic.)
> -- --
> JoeBrown_at_southeast.net http://users.southeast.net/~joebrown
> Joe Brown - Have a great day!!!
>
>
>
>>>>
The temporary tablespace is used by oracle for large sorts, index builds, holding  select sets from subqueries, etc. The objects in the temporary tablespace are created and deleted by oracle as needed. Received on Mon Jul 15 1996 - 00:00:00 CEST

Original text of this message