RE: Global Temp Tables and Indexes

Jack,
 Those rows will be stored in session's PGA in the sort areas (sort_area_size). When you insert more rows to fill up sort_area_size, you will see the table using your temporary tablespace. Or you can alter your session to use much smaller sort_area_size. Also, you can check v$sort_usage view to see how the numbers change as you add to the GTT.

 Hope this helps,

• Kirti Deshpande Verizon Information Services http://www.superpages.com

> -----Original Message-----
> From: Jack C. Applewhite [SMTP:japplewhite_at_inetprofit.com]
> Sent: Wednesday, June 27, 2001 7:01 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Global Temp Tables and Indexes
>
> Hi,
>
> Using Oracle8i 8.1.6...
>
> I've created a Temp table and inserted a couple of rows, but there seems
> to
> be no way to verify that it's segment(s) is(are) in the temp tablespace of
> the creating user. I've looked at every USER*, DBA*, and v$* view I can
> find - Tablespace_Name is null in all of them. I inserted the rows
> because
> I know that the first extent of a temp table is not allocated until the
> first insert.
>
> I'd like to see that the segment is where I think it is because I want
> another user whose temp t.s. is on another drive to create an index on
> that
> table. That's the only way I can think of to get an index on a temp table
> in another tablespace - for performance considerations.
>
> Anybody know how to verify the tablespace? Will my proposed method for
> getting the temp index on the temp table on another drive work? Any
> suggestions?
>
> Thanks.
>
> Jack
>
> --------------------------------
> Jack C. Applewhite
> Database Administrator/Developer
> OCP Oracle8 DBA
> iNetProfit, Inc.
> Austin, Texas
> www.iNetProfit.com
> japplewhite_at_inetprofit.com
> (512)327-9068
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jack C. Applewhite
> INET: japplewhite_at_inetprofit.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).