How to rebuild unusable index in oracle?

Asked by Lindsay

Report
in progress 61
7 Answers 313 views

Leave a reply to Lindsay : rebuild unusable index in oracle


Answers ( 7 )

  1. Mercy

    Yes, that will rebuild the idx_city_state index in the sales_us tablespace. You can write a bit of dynamic SQL to rebuild all the indexes. DECLARE l_sql_stmt …
    Read More

    Ratings : 32 %   

      
  2. Cynthia

    How to find Table Fragmentation in Oracle Database What is Oracle Table Fragmentation? If a table is only subject to inserts, there will not be any
    Read More

    Ratings : 37 %   

      
  3. Red Bill

    Important update: The rules for identification of candidates for index coalescing/rebuilding depend on your specific index state.
    Read More

    Ratings : 24 %   

      
  4. Crazyleg Jim

    NO: DO NOT USE "ALTER INDEX(...)REBUILD" for Text indexes!!!!! There are special provided packages for this: CTX_DDL w/o more specifics I will be unable to provide
    Read More

    Ratings : 72 %   

      
  5. Voodoo Bill

    Oracle indexes can go into a UNUSABLE state after maintenance operation on the table or if the index is marked as 'unusable' with an ALTER INDEX command.
    Read More

    Ratings : 46 %   

      
  6. Prudence

    Oracle Core, Лекция 4 :

    how to rebuild unusable index in oracle

    Ratings : 41 %