-
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 ..
Raghu
-
In 8i RECOVERABLE/UNRECOVERABLE is replaced by LOGGING/NOLOGGING. Not sure about 8.
Sanjay
-
Interesting extent sizes... I foresee fragmentation in your future.
OCP 8i, 9i DBA
Brisbane Australia
-
If ur using version 8 and above its unrecoverable and if its version 7.3 then its nologing.
cheese
anandkl
anandkl
-
Originally posted by anandkl
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 round
-
-
uh that´s ok everyone make mistakes! dont need to sorry
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
|