Re: Temporary table

In article <4sf43a$9lo_at_jaxnet.southeast.net> joebrown_at_southeast.net (Diamond Joe Shmengie) 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.)
>

Intermediate stages of SQL processing. See the concepts manual about temporary segments.

Now that 7.3 allows unlimited extenting, I'll bet Oracle will have this feature "soon."

-- 
Joel Garry               joelga_at_rossinc.com               Compuserve 70661,1534
These are my opinions, not necessarily those of Ross Systems, Inc.   <> <>
%DCL-W-SOFTONEDGEDONTPUSH, Software On Edge - Don't Push.            \ V /
panic: ifree: freeing free inodes...                                   O