Re: Where is a Temporary table stored?

From: Peter <peter_at_nomorenewsspammin.ca>
Date: Wed, 21 May 2003 19:04:26 GMT
Message-ID: <abjncv07cph3vj2f6kr9qsipvlstp7ilqm@4ax.com>

On Tue, 20 May 2003 16:19:14 -0700, Daniel Morgan <damorgan_at_exxesolutions.com> wrote:

>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.

This is only the recommended setting, right? Oracle is not forcing you to do it. Received on Wed May 21 2003 - 14:04:26 CDT