Re: ORA-01652: unable to extend temp segment

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Mon, 23 Jan 2006 15:43:23 -0600
Message-ID: <01ad01c62066$0b258880$c7bc21c8@porgand>

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_at_dp7uptx.com ; Michael McMullen ; Oracle-L_at_Freelists. Org (E-mail) Sent: Monday, January 23, 2006 2:38 PM Subject: RE: ORA-01652: 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.

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

Received on Mon Jan 23 2006 - 15:43:23 CST