| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Question about temporary segments
Ah, the joys of temporary segments. The temporary tablespace is used
for sorts. The problem you are experiencing is oracle is trying to build
an index and it does so kind of in the background and then switches
everything
around. So it is creating physical objects that are only there temporarily.
That is done in a users default tablespace or the tablespace you are
building
the index in. So if you are building an object then its in a 'regular
tablespace'
but if you have an order by, group by, union, etc, its in the temporary
tablespace.
Clear as mud?
-----Original Message-----
Sent: Thursday, October 18, 2001 1:15 PM
To: Multiple recipients of list ORACLE-L
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).
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 - 15:54:55 CDT
 |
 |