RE: ORA-01652: unable to extend temp segment

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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Joseph Amalraj
Sent: Tuesday, January 24, 2006 9:59 AM
To: ORACLE-L
Subject: Re: ORA-01652: 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@xxxxxxx> 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.
         

                 


BEGIN:VCARD
VERSION:2.1
N:Bobak;Mark
FN:Bobak, Mark
ORG:ProQuest Information and Learning;Database Group
TITLE:Software Architect, Sr-TPD
TEL;WORK;VOICE:734.975.6086
ADR;WORK:;ECC4-N01E04;1400 Eisenhower Parkway
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:ECC4-N01E04=0D=0A1400 Eisenhower Parkway
EMAIL;PREF;INTERNET:Mark.Bobak@xxxxxxxxxxxxxxx
REV:20051213T223654Z
END:VCARD

Other related posts: