Mike,
Your not seeing things. When you create an object, table, index, etc... the
database originally creates them as temporary objects. Assuming that the create
statement succeeds they then get automatically renamed to what you call them.
Having them as temporary objects I presume makes PMON's job of finding those
objects that need cleanup easier.
Dick Goulet
____________________Reply Separator____________________
Author: "Petrus; Mike (CAP; GEFA)" <[EMAIL PROTECTED]>
Date: 10/18/2001 12:15 PM
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: [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Petrus, Mike (CAP, GEFA)
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
