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: Tanel Poder <tanel.poder.003@xxxxxxx>
  • To: chris_stephens@xxxxxxxxxxxx, 'oracle-l' <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 02 Dec 2006 00:07:39 +0800
 
Enable auditing on any DDL on this table.. this should give you some insight
if it happens again..
 
 
Tanel.


  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Stephens, Chris
Sent: Friday, December 01, 2006 23:41
To: oracle-l
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.
 
by email reply. 





[ 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.