Re: Temporary Table

From: Fraser McCallum <fmcc_at_removetoemail_odbaguru.com>
Date: Tue, 9 Jul 2002 21:38:02 +1000
Message-ID: <fOzW8.31319$Hj3.94633@newsfeeds.bigpond.com>

Hugo,

If I understand what you are describing correctly, users all create effectively the same temporary tables but can only see their own, then yes this is possible as of Oracle 8i. Check out the "Create Global Temporary Table" command in your Oracle documentation.

Kind regards,

Fraser McCallum
MVP Oracle Administration
www.brainbench.com

"Hugo Habicht" <xyzabc103_at_hotmail.com> wrote in message news:25wW8.198731$IR.3020849_at_news.chello.at...
> Hi there,
>
> I´m coming from SQL Server and I used temporary Tables for storing
temporary
> Data. The Problem is we use the Database in MultiUser environment. In SQL
> Server a temporary Table exists only in the UserProcess. So each User
> creates his own Table.
> Is this possible in Oracle or is there a Workaround?
>
> thanks
>
> Hugo
>
>
Received on Tue Jul 09 2002 - 06:38:02 CDT