-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|