Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: temporary tables
No. When inserting data, each user
acquires completely independent
extents in the temporary tablespace.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Dan wrote in message <37F52265.D88D33A3_at_onshare.com>...
>In order to avoid hard-drive writes, I can use temporary tables as
>follows:
>
>CREATE GLOBAL TEMPORARY TABLE foo(var1 integer) ON COMMIT PRESERVE ROWS;
>
>I realize that this table is only alive for the current session; I don't
>mind that.
>
>The question is, is there any way to access rows of this table through
>another session / another connection to the database with the same
>user? Although the table information is visible in each session where
>the user is connected, individual rows are not visible across sessions.
>
>Thanks,
>
>Dan
>
Received on Sat Oct 02 1999 - 01:35:28 CDT
![]() |
![]() |