RE: ORA-1578...block corrupted...error is normal...a block...had a NOLOGGING...operation performed against

  • From: "Joel Garry" <joelgarry@xxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 19 Aug 2005 11:19:09 -0700

>Does the NOLOGGING attribute stay with the index after it has been
created?  It doesn't, >correct?


Obviously, getting the error shows that it does.  And perhaps reading
something into the 26040 error, it must be tracked by block, maybe
something in the Integrity Section at the beginning of the block... 10g
might be more informative

I'm also wondering if analyze...validate might tell us anything.  Then
again, if this is expected behavior, would it be a misfeature if analyze
didn't pick it up?

Joel Garry


Other related posts: