Re: URGENT HELP ME!

Maybe you were not able to rebuild all indexes associated with that table you moved yesterday. Anyhow, suggest you just find all the UNUSABLE indexes and rebuild them.

select table_name, index_name
from dba_indexes
where status = 'UNUSABLE';

table_name here is most likely the table you moved. Then for each row you find there,

alter index index_name rebuild; -- can add nologging clause for faster rebuild.

The above suggestions are assuming that you're not dealing with partitioned indexes/tables. If you are, holler or better yet read the Administration Guide (http://tahiti.oracle.com). Once you're done putting out this fire, do visit that site.

HTH. 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 - 08:51:33 CEST