Re: URGENT HELP ME!

hi,
u have 2 options: drop and recreate the index or rebuild the index using steps below

1. check which indexes status in ('INVALID' OR 'UNUSABAL') FORM DBA_INDEXES, USER_INDEXS
2. rebuild it using these command: alter index indexname rebuild tablespace tablespacename;

good luck

tracykim10_at_yahoo.com.hk (tracy) wrote in message news:<5c91cce9.0406221852.3ec8ca35_at_posting.google.com>...
> Hi,
> I need help urgently. Yesterday i move a tables and indexes to
> different tablespace using these command:
> alter table my_table move tablespace xyz;
> alter index my_index rebuild tablespace xyz;
>
> now my db got this error:
> ORA-01502 index 'string.string' or partition of such index is in
> unusable state
> for idx_cesdetail_ces_main_item
>
> User found out a lot of such indexes. why? and how to fix it.
>
> regards,
> tracy
Received on Wed Jun 23 2004 - 10:06:11 CEST