Re: Rebuilding large index problem

Let's compare what Oracle most likely does

alter index rebuild
create index
get dictionary definition
build temporary segment
build temporary segment
drop original index
create new index as temp segment in destination tablespace create new index as temp segment in destination tablespace

rename the temporary segment to index_name rename the temporary segment to index_name

so Yes, most likely you will run into the same issue.

--
Sybrand Bakker, Oracle DBA
Tony Adolph <tony.adolph_at_viaginterkom.de> wrote in message news:7vu6cl$a1n$1_at_nnrp1.deja.com...
> Hello All,
>
> I am trying to rebuild a 2.5 Gbyte index using:
>
> alter index <owner>.<index name> rebuild
> tablespace <new tablespace name> storage (initial <n> M next <n> M);
>
> but am running out of TEMP tablespace.
>
> The problem is that I do not have very much space to allocate to TEMP.
> If I drop the index and re-create it rather than using "alter index
> rebuild..." will I be using TEMP in the same way and hence have the
> same problem?
>
> Thanks for any input,
> Tony Adolph
>
> PS: Ora 7.3.4 on NT4
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Nov 05 1999 - 03:18:48 CST