Re: Temp table space

In article <56frrb$olk_at_portal.gmu.edu>,

   dnguyeb_at_site.gmu.edu (Dong Duong Nguyen (SSE)) wrote:
>Hello,
> Can you create a temporary table in the temp table space? Can you
>create it so that the table gets destroyed when you disconnect or when
>a trasaction finishes?

no, tables you create yourself do not have that property even if you create them in the temporary tablespace. generally, the DBA does not grant you any quota in the temp tablespace so you cannot create one there.

--
Dave Mausner, Consulting Manager, Braun Technology Group, Chicago.