RE: ORA-01652: unable to extend temp segment
- From: Joseph Amalraj <joseph@xxxxxxxxxxxxxx>
- To: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>, joseph@xxxxxxxxxxxxxx, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 24 Jan 2006 07:48:23 -0800 (PST)
Thanks,
Had read the article, but I am interested as to why Oracle is doing a full
table scan instead of full index scan for online index rebuilds.
"Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx> wrote:
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:
