Rebuilding index
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Rebuilding index

  1. #1
    Join Date
    Aug 2001
    Posts
    35

    Rebuilding index

    Hi,
    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.
    thanks
    vennai

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    what kind of tablespace are you creating it in?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Aug 2001
    Posts
    35
    Tablespace is locally managed.

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Extent management automatic or uniform?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #5
    Join Date
    Aug 2001
    Posts
    35
    Extent management automatic or uniform? - extent management is automatic.Is there any way to solve the problem

    Thanks
    Venkat

  6. #6
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  7. #7
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by vennai
    extent management is automatic
    is the reason why your storge parms are ignored.
    funky...

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width