Partition Index Problem
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Partition Index Problem

  1. #1
    Join Date
    Sep 2006
    Posts
    114

    Partition Index Problem

    Dear Sir Please take a look at the attachment and plz suggest where is the problem
    i am in greate trouble
    can u plz help me in this regard?

    Somebody was saying that it is problem in tablespace
    but i'll not agree with him
    Because i didn't do anything with tablespace
    Last time we have moved tables to different tablespace as well as rebuild indexes
    is it the reason that some partition of indexes are not moved and become unusable
    if it is understandable for u then plzz help me in this regard
    it is very urgent Sir

  2. #2
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    ma'm correction....well, if i were in ur place i'll drop and recreate
    the indexes pointing to the new tablespace, its faster than rebuilding....based on my experience
    Last edited by yxez; 10-06-2006 at 02:09 AM.
    Behind The Success And Failure Of A Man Is A Woman

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    what are you talking about? there is no attachment and your post doesnt make any sense

  4. #4
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    sorry davey...but his english is not so clear ....as what my understanding is...that the indexes where unusable after he moved
    the tables....so the option is to recreate them.
    Behind The Success And Failure Of A Man Is A Woman

  5. #5
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Quote Originally Posted by yxez
    ma'm correction....well, if i were in ur place i'll drop and recreate
    the indexes pointing to the new tablespace, its faster than rebuilding....based on my experience
    ... but more error prone and difficult to code, I'd say
    David Aldridge,
    "The Oracle Sponge"

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

    Oracle ACE

  6. #6
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Quote Originally Posted by yxez
    ma'm correction....well, if i were in ur place i'll drop and recreate
    the indexes pointing to the new tablespace, its faster than rebuilding....based on my experience
    Drop and re-create will mean you are doing a full table scan of the table the index is based on.

    Rebuilding (provided you have the space to do it), will do a fast full scan of the index (assuming Oracle can read all the blocks).

    I'd rebuild it if I could.
    Assistance is Futile...

  7. #7
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Quote Originally Posted by waitecj
    Rebuilding (provided you have the space to do it), will do a fast full scan of the index (assuming Oracle can read all the blocks).
    Not if the index is unusable.
    David Aldridge,
    "The Oracle Sponge"

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

    Oracle ACE

  8. #8
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Duh! Silly me. Next time i'll read the post a little more carefully before responding.

    I even said "assuming Oracle can read all the blocks" in my original reply!!
    Last edited by waitecj; 10-06-2006 at 11:51 AM.
    Assistance is Futile...

  9. #9
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    thanks voyz ....david, do you mean that im right and not wild?
    Behind The Success And Failure Of A Man Is A Woman

  10. #10
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Quote Originally Posted by yxez
    thanks voyz ....david, do you mean that im right and not wild?
    You haven't fully explained your problem yet. There is no attachment to your post.
    David Aldridge,
    "The Oracle Sponge"

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

    Oracle ACE

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