ORA-01652: unable to extend temp segment 2006-01-23 - By Roger Xu
SQL> alter index "SAPR3"."VBFA~0" rebuild online parallel 3 tablespace
PSAPREROGI;
*
ERROR at line 1:
ORA-12801 (See ORA-12801.ora-code.com): error signaled in parallel query server P001
ORA-01652 (See ORA-01652.ora-code.com): unable to extend temp segment by 89595 in tablespace PSAPREROGI
I got ORA-01652 (See ORA-01652.ora-code.com) 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@(protected)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2180" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2>SQL> alter index "SAPR3"."VBFA~0" rebuild
online
parallel 3 tablespace PSAPREROGI<SPAN
class=685312119-23012006>;</SPAN><BR>*<BR>ERROR at line 1:<BR>ORA-12801 (See ORA-12801.ora-code.com): error
signaled in parallel query server P001<BR>ORA-01652 (See ORA-01652.ora-code.com): unable to extend temp
segment by 89595 in tablespace PSAPREROGI</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN class=685312119-23012006><FONT face=Arial size=2>I got ORA-01652 (See ORA-01652.ora-code.com)
while rebuilding the 14 GB index to a new tablespace and the
tablespace</FONT></SPAN></DIV>
<DIV><SPAN class=685312119-23012006><FONT face=Arial size=2>has 16 GB free
space. Before the error occurred, the 31 GB temp tablespace had 13.5 GB
</FONT></SPAN></DIV>
<DIV><SPAN class=685312119-23012006><FONT face=Arial
size=2>used.</FONT></SPAN></DIV>
<DIV><SPAN class=685312119-23012006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=685312119-23012006><FONT face=Arial size=2>Any idea why it
created temp segments in the target tablespace? </FONT></SPAN></DIV>
<DIV><SPAN class=685312119-23012006></SPAN><SPAN class=685312119-23012006><FONT
face=Arial size=2>How big the target tablespace would be? I thought 16 GB is
enough.</FONT></SPAN></DIV>
<DIV><SPAN class=685312119-23012006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=685312119-23012006><FONT face=Arial
size=2>Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=685312119-23012006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=685312119-23012006><FONT face=Arial
size=2>Roger</FONT></SPAN></DIV>
<BR>
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.
<BR>
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ _____<BR>
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@(protected)<BR>
</BODY></HTML>
|
|
