Re: RE: Re: Oracle XE Corruption

  • From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 25 Aug 2010 13:50:39 -0500 (CDT)

Niall wrote:

> 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

I would hope that the act of an index being marked unusable would also
invalidate its dependent cursors or perhaps those of the table.

But try and confirm that via docs....whew!

Rich

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


Other related posts: