Go to the FreeLists Home Page Home Signup Help Login
 



[oracle-l] || [Date Prev] [12-2006 Date Index] [Date Next] || [Thread Prev] [12-2006 Thread Index] [Thread Next]

Re: Index unusable

  • From: Sunil Bhola <oraclebhola@xxxxxxxxx>
  • To: chris_stephens@xxxxxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 1 Dec 2006 10:22:30 -0800 (PST)
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.




[ Home | Signup | Help | Login | Archives | Lists ]

All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
Everything else ©2007 Avenir Technologies, LLC.