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

Thread: Rebuilding index

  1. 09-24-2003, 12:50 PM #1
    vennai
    vennai is offline Registered User
    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
    Reply With Quote Reply With Quote
  2. 09-24-2003, 02:00 PM #2
    slimdave
    slimdave is offline Foreign Script Kiddie
    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
    Reply With Quote Reply With Quote
  3. 09-24-2003, 02:49 PM #3
    vennai
    vennai is offline Registered User
    Join Date
    Aug 2001
    Posts
    35
    Tablespace is locally managed.
    Reply With Quote Reply With Quote
  4. 09-24-2003, 02:56 PM #4
    slimdave
    slimdave is offline Foreign Script Kiddie
    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
    Reply With Quote Reply With Quote
  5. 09-24-2003, 04:25 PM #5
    vennai
    vennai is offline Registered User
    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
    Reply With Quote Reply With Quote
  6. 09-24-2003, 04:41 PM #6
    slimdave
    slimdave is offline Foreign Script Kiddie
    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
    Reply With Quote Reply With Quote
  7. 09-25-2003, 12:24 AM #7
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    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"
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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