Re: Index unusable

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.

Other related posts: