Re: Where is TEMP TABLE created?

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 28 Jul 2005 00:23:48 -0700
Message-ID: <1122535394.224427@yasure>

Ken wrote:
> If I issue CREATE GLOBAL TEMPORARY TABLE, which tablespace will the temp
> table created on? I queried the user_table data dict and the TABLESPACE col
> for the temp table is NULL! So which tablespace is holding the temp table?

I beg to differ with Sybrand on this ... GTT's are created in the TEMP tablespace.

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14220/schema.htm#sthref764 "Temporary tables use temporary segments."

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Thu Jul 28 2005 - 02:23:48 CDT