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

Thread: ALTER TABLE REBUILD UNUSABLE INDEX

  1. #1
    Join Date
    Nov 2000
    Posts
    205
    ALTER TABLE REBUILD UNUSABLE INDEX

    To use this statement, is it only against one table or against all tables in the particular schema?

    Thanks,
    Nirasha

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    One table
    Jeff Hunter

  3. #3
    Join Date
    Nov 2000
    Posts
    205
    I tried this and it did not work.

    I tried first ALTER TABLE REBUILD UNUSABLE INDEX
    and then I tried ALTER TABLE xxx REBUILD UNUSABLE INDEX and it still did not work.

    Eventually I used dynamic SQL to do them one at a time. What was I doing wrong?

    Thanks,
    Nirasha

  4. #4
    Join Date
    Jun 2000
    Posts
    295
    I remember you can rebuild local indexes
    one partition once only.

    So it is against one partition.

    alter table xxx modify partition xxx_part1 rebuild unusable local indexes;


  5. #5
    Join Date
    Nov 2000
    Posts
    205
    I just saw this :
    REBUILD UNUSABLE LOCAL INDEXES rebuilds the unusable local index subpartitions associated with subpartition

    but my table was not partitioned. I did not try with alter table xxx rebuild unusable local indexes.

    DO you think it would have worked had I typed it in like that, or is this specific to partitioned tables???

    Thanks,
    Nirasha

  6. #6
    Join Date
    Jun 2000
    Posts
    295
    "DO you think it would have worked had I typed it in like that, or is this specific to partitioned tables??? "

    I do not think so. Oracle will give you error message to complain about partition does not exist, or so error.

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