ORA-01652: unable to extend temp segment 2006-01-23 - By Tanel Poder
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.
-- -- Original Message -- --
From: Joseph Amalraj
To: roger_xu@(protected) ; Michael McMullen ; Oracle-L@(protected) Org (E-mail
)
Sent: Monday, January 23, 2006 2:38 PM
Subject: RE: ORA-01652 (See ORA-01652.ora-code.com): unable to extend temp segment
For rebuild operations, twice the index space is used during the rebuild, as
Oracle constructs the new index from the old one.
The space is released once the index is rebuilt.
<!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>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<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
online, 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">
<DIV style="FONT: 10pt arial">-- -- Original Message -- -- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=joseph@(protected) href="mailto:joseph@(protected)">Joseph
Amalraj</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=roger_xu@(protected)
href="mailto:roger_xu@(protected)">roger_xu@(protected)</A> ; <A
title=ganstadba@(protected) href="mailto:ganstadba@(protected)">Michael
McMullen</A> ; <A title=oracle-l@(protected)
href="mailto:Oracle-L@(protected) Org (E-mail)">Oracle-L@(protected) Org
(E-mail)</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, January 23, 2006 2:38
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: ORA-01652 (See ORA-01652.ora-code.com): unable to extend
temp segment</DIV>
<DIV><BR></DIV>
<DIV>For rebuild operations, twice the index space is used during the rebuild
,
as Oracle constructs the new index from the old one.</DIV>
<DIV> </DIV>
<DIV>The space is released once the index is rebuilt.
<BR><BR></DIV></BLOCKQUOTE></BODY></HTML>
|
|
