Hello All,
I have to rebuild some of the indexes ( which are big in size ), in version 8.0.4 , I am planning to use

alter index ADMINUSER.I_SHADDR1 rebuild unrecoverable tablespace SHOPIDX storage ( initial 48046080
next 12011520
pctincrease 0
minextents 1
maxextents 100)
pctfree 0 ;

In the above syntax , will UNRECOVERABLE is valid ????
or can i use NOLOGGING ???

And What happens if the Index rebuild fails , will the old index still exists ???


Thanks,
Madhu