Re: Index unusable

From: Sunil Bhola <oraclebhola_at_yahoo.com>
Date: Fri, 1 Dec 2006 10:22:30 -0800 (PST)
Message-ID: <546148.19160.qm@web56208.mail.re3.yahoo.com>

Hi Stephens,  

Are you rebuilding you tables? thru move command...  

Regards,
Sunil Bhola

• Original Message ----- From: Stephens, Chris To: oracle-l Sent: Friday, December 01, 2006 9:11 PM Subject: Index unusable

  2x this week a non-partitioned pk index has become unusable preventing inserts into the table.    

  there has been no ddl on the table.    

  i can only find documentation on what causes partitioned indexes to be unusable.    

  anybody know of a possible reason for this to be occuring?

CONFIDENTIALITY NOTICE:
This message is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by email reply.  

---

Check out the all-new Yahoo! Mail beta - Fire up a more powerful email and get things done faster.
--

http://www.freelists.org/webpage/oracle-l Received on Fri Dec 01 2006 - 12:22:30 CST