ORA-01652: unable to extend temp segment 2006-01-24 - By Bobak, Mark
Well, my name is not Tanel, but I'll jump in here and point you to MetaLink Doc
ID 272762.1.
-Mark
--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning
"There are 10 types of people in the world: Those who understand binary, and
those who don't."
__ ____ ____ ____ ____ ____ ____
From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] On
Behalf Of Joseph Amalraj
Sent: Tuesday, January 24, 2006 9:59 AM
To: ORACLE-L
Subject: Re: ORA-01652 (See ORA-01652.ora-code.com): unable to extend temp segment
Thanks Tanel,
Is there any reason why Oracle does full table scans for online rebuilds and
not for offline.
Regards
Joseph Amalraj
Tanel Põder <tanel.poder.003@(protected)> wrote:
Online rebuilds don't use existing index for creating new. They do full table
scan on the table.
However, in both cases, old index segment is kept until new one is ready to
use and switch to it is done. Also the journal IOTs used for online rebuilds
are stored in the target tablespace, so if you've got lots of transactions
going on while you are rebuilding the index onl ine, you need additional space
in target tablespace.
Tanel.
<!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.2802" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=640153815-24012006><FONT face=Arial
color=#0000ff size=2>Well, my name is not Tanel, but I'll jump in here and
point
you to MetaLink Doc ID 272762.1.</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=640153815-24012006><FONT face=Arial color=#0000ff
size=2>-Mark</FONT></SPAN></DIV><!-- Converted from text/rtf format -->
<P><B><SPAN lang=en-us><FONT face="Century Gothic" size=2>--</FONT></SPAN></B>
<BR><B><SPAN lang=en-us><FONT face="Century Gothic" size=2>Mark J.
Bobak</FONT></SPAN></B> <BR><B><SPAN lang=en-us><FONT face="Century Gothic"
size=2>Senior Oracle Architect</FONT></SPAN></B> <BR><B><SPAN lang=en-us><FONT
face="Century Gothic" size=2>P</FONT><FONT face="Century Gothic"
size=2>ro</FONT><FONT face="Century Gothic" color=#ff0000 size=2>Q</FONT><FONT
face="Century Gothic" size=2>uest Information & Learning</FONT></SPAN></B>
</P>
<P><SPAN lang=en-us><FONT face="Californian FB">"There are 10 types of people
in
the world: Those who understand binary, and those who
don't."</FONT></SPAN> </P>
<DIV> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] <B>On Behalf Of </B>Joseph
Amalraj<BR><B>Sent:</B> Tuesday, January 24, 2006 9:59 AM<BR><B>To:</B>
ORACLE-L<BR><B>Subject:</B> Re: ORA-01652 (See ORA-01652.ora-code.com): unable to extend temp
segment<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>Thanks Tanel, </DIV>
<DIV> </DIV>
<DIV>Is there any reason why Oracle does full table scans for online rebuilds
and not for offline.</DIV>
<DIV> </DIV>
<DIV>Regards</DIV>
<DIV> </DIV>
<DIV>Joseph Amalraj<BR><BR><B><I>Tanel Põder
<tanel.poder.003@(protected)></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR>
<STYLE></STYLE>
<DIV><FONT face=Arial size=2>Online rebuilds don't use existing index for
creating new. They do full table scan on the table.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>However, in both cases, old index segment 
;is
kept until new one is ready to use and switch to it is done. Also the journal
IOTs used for online rebuilds are stored in the target tablespace, so if
you've got lots of transactions going on while you are rebuilding the index
onl ine, you need additional space in target tablespace.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Tanel.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT:
#000000 2px solid; MARGIN-RIGHT: 0px"> </BLOCKQUOTE></BLOCKQUOTE></BODY><
/HTML>
|
|
