Question on temporary table?

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 Wed May 12 1999 - 12:48:55 CDT