Rebuilding large index problem

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:01:10 CST