Printable View
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
Still the old index will be good if the rebuild fails, better not to try with nologging option ..
In 8i RECOVERABLE/UNRECOVERABLE is replaced by LOGGING/NOLOGGING. Not sure about 8.
Sanjay
Interesting extent sizes... I foresee fragmentation in your future.
If ur using version 8 and above its unrecoverable and if its version 7.3 then its nologing.
cheese
anandkl
it´s the other way roundQuote:
Originally posted by anandkl
If ur using version 8 and above its unrecoverable and if its version 7.3 then its nologing.
cheese
anandkl
i am sorry
uh that´s ok everyone make mistakes! dont need to sorry ;)