Re: Question on temporary table?

Temporary table is a new feature of Oracle 8.1.

HTH. Finn

<rong_at_my-dejanews.com> wrote in message news:7hceu6$g1q$1_at_nnrp1.deja.com...
> Hi All,
>
> I have a question regarding temporary table. On SQL Server, it provides
> the feature of using temporary table. I have a performance issue which
> needs temporary table to solve it. In my case, I prefer to create the
> local temporary table. But on Oracle, there's no way to create the
> temporary table. But I may create a table for a short period and drop
> it after the application is over. But the thing is I have to be granted
> the right to create the table. During the running of application, we
> don't know who is gonna be the user. Therefore, we don't know for sure
> if the user has the privilege to create the table or not. I think there
> must be a way on Oracle to deal with the temporary table issue somehow.
> Can any body give me any good suggestion on this issue. Thanks for your
> response.
>
> Rita
>
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---
Received on Thu May 13 1999 - 04:15:46 CDT