Index marked unuseable
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-lReceived on Mon Apr 20 2009 - 14:24:19 CDT