But you may be able to use a trigger, on v$session....
When a session ends, it can attenpt to drop the specific table form your
specific tablespace. In theory, it sounds plausible. I have never
tried it.
Douglas Dunyan
--dm^noise_for_spammers^dunyan_at_hotmail.com
OCP ORACLE V7
MASTER OF TECHNOLOGY V8
Bas Haenraets wrote:
>
> As far as I know, you can't. The only tables that are automatically
> destroyed are created by Oracle itself (e.g. for sorting a large number
> of rows).
>
> > -----Original Message-----
> > From: news.ht.net.tw [SMTP:jjkkma_at_mail.ht.net.tw]
> > Posted At: Friday, October 16, 1998 8:25 AM
> > Posted To: server
> > Conversation: Can I create temp table in Oracle.
> > Subject: Can I create temp table in Oracle.
> >
> > In SQL Server, we can create a session temp table.
> > This temp table is indepandent with other session.
> > This table will auto destory when session closed.
> > Can I do it in Oracle?
> > How to do it.
> >
> > jjkk_at_mail.ht.net.tw
> >
Received on Sun Oct 25 1998 - 01:51:45 CST
