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 automatic
"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