RE: Index unusable

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Sat, 02 Dec 2006 00:07:39 +0800
Message-id: <023401c71562$d2fe54d0$6401a8c0@windows01>

Enable auditing on any DDL on this table.. this should give you some insight if it happens again..

Tanel.

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 01 2006 - 10:07:39 CST