Question about temporary segments

From: Petrus, Mike (CAP, GEFA) <Mike.Petrus2_at_gecapital.com>
Date: Thu, 18 Oct 2001 12:52:00 -0700
Message-ID: <F001.003AF1CB.20011018121518@fatcity.com>

Greetings All;
I am confused and hope someone can straighten me out.

My confusion surrounds temporary segments and where they are created. I had assumed that temporary segments were created in a user's, assigned temporary tablespace. However when I have a creation failure, for example, if I am attempting to rebuild an index that is currently in tablespace aww_index1, I received the following error: (ORA-1652: unable to extend temp segment by 1280 in tablespace AWW_INDEX1), this is telling me that the temp segment is being created in the tablespace that the permanent object exists in. Is this always the case? Is the only purpose of the user's, assigned "TEMPORARY" table space for sorting. Can I tell Oracle to redirect the creation of the temp segment to a different tablespace? If so how is that accomplished?

Thanks in advance.

Michael L. Petrus
GE Auto Warranty Services
7125 W. Jefferson Av. #200
Lakewood, CO 80235

Database Administrator

Phone: (303) 987 4129
Fax: (303) 987 4298
Email: Mike.Petrus2_at_gecapital.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Petrus, Mike (CAP, GEFA)
INET: Mike.Petrus2_at_gecapital.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). Received on Thu Oct 18 2001 - 14:52:00 CDT