ORA-01652: unable to extend temp segment 2006-01-24 - By Joseph Amalraj
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 online, you need additional space
in target tablespace.
Tanel.
<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>
|
|
