index error...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: index error...

  1. #1
    Join Date
    Nov 2000
    Location
    London
    Posts
    83
    After successuly moving the table from one tablespace to another, it now gives error

    ORA-01502: index 'GALAXY.SYS_C0028191' or partition of such index is in unusable state

    Is it possible to move indexes as well? Or rebuild of indexes the only solution to thins?

    Fiona

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Yes, you must rebuild the indexes when you move a table:
    alter index GALAXY.SYS_C0028191 rebuild;

    You can also move it at the same time with:
    alter index GALAXY.SYS_C0028191 rebuild tablespace new_tbs;
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Apr 2001
    Posts
    219
    Rebuild is your only option, becuase of the invalid rowids from the move.

  4. #4
    Join Date
    Jul 2001
    Posts
    15

    Rebuild or recreate?

    Can you rebuild the index or you have to drop it and recreate it? Because when you rebuild it, Oracle will use the old index to build the new one (does anyone know how?). My concern is that if the old index contains invalid rowid info, can you still use the index to rebuild a new one?

    tianhua

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    rebuild is like drop and recreate, in this case there is no difference between two because the index is unusable so in any case users cannot use it (I would guess recreate is a better way and save freespace)

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