Re: RE: Re: Oracle XE Corruption

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: daniel.fink@xxxxxxxxxxxxxx
  • Date: Wed, 25 Aug 2010 18:51:26 +0100

Methinks If it was marked unusable then the instance would likely have
crashed the first time smon used it as an access path to the data in that
table

On 25 Aug 2010 18:01, "Daniel Fink" <daniel.fink@xxxxxxxxxxxxxx> wrote:

I'm a little bothered by the fact that a known corrupt index would be used
to rebuild itself. I would expect
1) The rebuild to fail
2) The rebuild to use the table data as the source

One question in my mind is what was the index state? Was it still marked as
good in the data dictionary despite these errors? Should it not have been
marked as corrupt/unusable?

------- Original Message -------


On 8/25/2010 4:52 PM Jared Still wrote:
On Wed, Aug 25, 2010 at 9:22 AM, Evan Pettrey <jepettrey@xxxxx

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

Other related posts: