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

Home -> Community -> Usenet -> c.d.o.server -> Where is a Temporary table stored?

Where is a Temporary table stored?

From: Christian Hartmann <cha_at_christian-hartmann.de>
Date: Tue, 20 May 2003 22:34:46 +0200
Message-ID: <c84lcvo54llmre2rg49g5jbhknubtmqdph@4ax.com> 





Hi there,



I am running Oracle 8.1.7 and wonder myself, where the content of a
temporary table that was created using 



CREATE GLOBAL TEMPORARY TABLE ...



     [ON COMMIT DELETE ROWS ]


is stored. 



Is it stored in the SGA or in the PGA of the user-process, i.e. also
using the temporary tablespace?



Please let me know if you know it.... :-)



Regards,



Christian Hartmann
        
Received on Tue May 20 2003 - 15:34:46 CDT












Original text of this message













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