Re: considerations for rebuilding and coalescing

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1157130476.543350_at_bubbleator.drizzle.com...
> Ben wrote:
>
>> The TEMP space that is used, is that actually in the TEMP tablespace or
>> is that TEMP space in the tablespace that you are building the index?
>
> TEMP tablespace.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

Although there is also a period where the index is being created in the target tablespace. Whilst the build is taking place, the thing being constructed is also marked as a temporary segment. This allows for an automatic cleanup if the instance (or session) happens to crash before the build is complete.

-- 
Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html