Re: Rebuilding large index problem

Try to recreate the index using NOSORT option with CREATE INDEX command to avoid sorts using temporary tablespace. It will work if data in this table is "presorted". If not, CREATE INDEX ... NOSORT will just fail.

Good luck,
Eugene.

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 - 08:32:09 CST