Re: Temp table space

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?
>
> Thanks
> Doug Nguyen

i don't believe you can.
however, why don't you create a package with a pl/sql table defined in the package header, this pl/sql table will be private per session. you can populate it as you will, and the package is 'reset' when the session is closed.

hope this helps

--
Gert Rijs
mailto:gem_at_wirehub.net    (at home)
mailto:gert.rijs_at_corp.ah.nl (at work)