Index marked unuseable

From: Saad Khan <saad4u_at_gmail.com>
Date: Mon, 20 Apr 2009 15:24:19 -0400
Message-ID: <76b3d4e30904201224v51232bbdtbacd94a350ad4960_at_mail.gmail.com>



Hi Guyz,

I've Datamart running in a new database which just went live yesterday. We have ETL running for it. Since last few days, I've been seeing TONS of following messages in the alert file during the time whenever ETL is run.

The most wierd thing is that, when I checked user_indexes and user_ind_subpartitions, the status column shows every index as USABLE. This is puzzling.
Does anyone have any idea why such messages are being generated and if these are legitimate messages, why the indexes are still usable?

Messages in logfile:
*Index<username>.<indexname> or some [sub]partitions of the index have been marked unusable
Mon Apr 20 11:42:43 2009
Index<username>.<indexname> or some [sub]partitions of the index have been marked unusable
Mon Apr 20 11:42:43 2009
Index<username>.<indexname> or some [sub]partitions of the index have been marked unusable
Mon Apr 20 11:42:43 2009
Index<username>.<indexname> or some [sub]partitions of the index have been marked unusable*

Thanks,
Saad

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 20 2009 - 14:24:19 CDT

Original text of this message