Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Where is a Temporary table stored?
Christian Hartmann wrote:
> 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
>
The TEMP tablespace.
-- Daniel Morgan http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Tue May 20 2003 - 18:19:14 CDT