I am trying to rebuild the indexes,even though i specify Intial =16k and Next = 16k ,pct increase = 0,the value it is showing after rebuiling is intial = 16k and next = 1024k.why it is so.can anyone explain me.
what kind of tablespace are you creating it in?
Tablespace is locally managed.
Extent management automatic or uniform?
Extent management automatic or uniform? - extent management is automatic.Is there any way to solve the problem
You could rebuild it in a uniform-extent tablespace. Alternatively, you could just ignore it -- is there a particular reason why you don't want those extent sizes?
is the reason why your storge parms are ignored.
Originally posted by vennai
extent management is
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Click Here to Expand Forum to Full Width