RE: Index unusable

From: Stephens, Chris <chris_stephens_at_admworld.com>
Date: Fri, 1 Dec 2006 12:39:20 -0600
Message-ID: <7070047601C21A4CB387D50AD3661F6E05ACF818@050EXCHANGE.research.na.admworld.com>

I don't believe so.

I thought I was the only one that would have performed any ddl on this table so I didn't check last_ddl_time until an hour or so ago. It shows 01-DEC-06 12.00.00.000000000 AM. I am still trying to track down exactly what was done at that time.

at tanel's suggestion, i have enabled ddl auditing on the table.

thanks
chris

From: Sunil Bhola [mailto:oraclebhola_at_yahoo.com] Sent: Friday, December 01, 2006 12:23 PM To: Stephens, Chris; oracle-l
Subject: Re: Index unusable

Hi Stephens,

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

Regards,
Sunil Bhola

Original Message ----- From: Stephens, Chris <mailto:chris_stephens_at_admworld.com> To: oracle-l <mailto:oracle-l_at_freelists.org> 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
<http://us.rd.yahoo.com/evt=43257/*http://advision.webevents.yahoo.com/m ailbeta> - Fire up a more powerful email and get things done faster.

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.

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

Received on Fri Dec 01 2006 - 12:39:20 CST