RE: Index unusable
- From: "Stephens, Chris" <chris_stephens@xxxxxxxxxxxx>
- To: "Sunil Bhola" <oraclebhola@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 1 Dec 2006 12:39:20 -0600
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@xxxxxxxxx]
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@xxxxxxxxxxxx>
To: oracle-l <mailto:oracle-l@xxxxxxxxxxxxx>
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.
Other related posts:
