URGENT HELP ME!
From: tracy <tracykim10_at_yahoo.com.hk>
Date: 22 Jun 2004 19:52:38 -0700
Message-ID: <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;
Date: 22 Jun 2004 19:52:38 -0700
Message-ID: <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 - 04:52:38 CEST