Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: temporary tables

Re: temporary tables

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 2 Oct 1999 07:35:28 +0100
Message-ID: <938846138.6765.0.nnrp-03.9e984b29@news.demon.co.uk>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US