RE: ORA-01652: unable to extend temp segment

But he specified that he was building the index in a new, unused,
tablespace.

 

Jay Miller

 

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 
Sent: Monday, January 23, 2006 3:38 PM
To: roger_xu_at_dp7uptx.com; Michael McMullen; Oracle-L_at_Freelists. Org
(E-mail)
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. 







-----------------------------------------
This message is confidential and sent by TD Waterhouse solely for
use by the intended recipient. If you are not the intended
recipient, you are hereby notified that any use, distribution or
copying of this communication is strictly prohibited. This should
not be deemed as an offer or solicitation, to buy or sell any
product. Any 3rd party information contained herein was prepared by
sources deemed reliable, but is not guaranteed. TD Waterhouse does
not accept electronic instructions that would require an original
signature. Information received by or sent from TD Waterhouse is
stored, subject to review, and may be produced to regulatory
authorities or others with a legal right to such.

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