RE: ORA-01652: unable to extend temp segment

Oracle always creates segments of type TEMP while building a new index.
They are converted to the appropriate segment type once the object
creation is finished.  

 

 

Thanks,

Jay Miller

Sr. Oracle DBA

x68355

 

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 
Sent: Monday, January 23, 2006 2:31 PM
To: Oracle-L_at_Freelists. Org (E-mail)
Subject: ORA-01652: unable to extend temp segment 

 

SQL> alter index "SAPR3"."VBFA~0" rebuild online parallel 3 tablespace
PSAPREROGI;
*
ERROR at line 1:
ORA-12801: error signaled in parallel query server P001
ORA-01652: unable to extend temp segment by 89595 in tablespace
PSAPREROGI

 

I got ORA-01652 while rebuilding the 14 GB index to a new tablespace and
the tablespace

has 16 GB free space. Before the error occurred, the 31 GB temp
tablespace had 13.5 GB 

used.

 

Any idea why it created temp segments in the target tablespace? 

How big the target tablespace would be? I thought 16 GB is enough.

 

Thanks,

 

Roger


This e-mail is intended solely for the person or entity to which it is
addressed and may contain confidential and/or privileged information.
Any review, dissemination, copying, printing or other use of this e-mail
by persons or entities other than the addressee is prohibited. If you
have received this e-mail in error, please contact the sender
immediately and delete the material. 
____________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email
Security System. Any questions please call 972-721-8257 or email your
request to tech_support_at_dp7uptx.com.




-----------------------------------------
This message is confidential and sent by TD Waterhouse solely for
use by the intended recipient. If you are not the intended
recipient, you are hereby notified that any use, distribution or
copying of this communication is strictly prohibited. This should
not be deemed as an offer or solicitation, to buy or sell any
product. Any 3rd party information contained herein was prepared by
sources deemed reliable, but is not guaranteed. TD Waterhouse does
not accept electronic instructions that would require an original
signature. Information received by or sent from TD Waterhouse is
stored, subject to review, and may be produced to regulatory
authorities or others with a legal right to such.

--
http://www.freelists.org/webpage/oracle-l