Re: ORA-01652: unable to extend temp segment

From: Joseph Amalraj <joseph_at_amalrajinc.com>
Date: Tue, 24 Jan 2006 06:59:22 -0800 (PST)
Message-ID: <20060124145922.14927.qmail@web312.biz.mail.mud.yahoo.com>

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_at_mail.ee> 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.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jan 24 2006 - 08:59:22 CST