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