Re: so many corrupt blocks???

Paul Drake wrote:
> Is it possible that the blocks are marked as corrupt due to nologging
> operations?
> I have seen where a nologging operation has left a block marked as
> corrupted, when in fact there isn't really a corruption issue.
>
> Are these data segments, or just indexes - can you simply rebuild
> them?

In fact, I did turn off logging for a large data import. But in addition to that ther was a faulty memory module

> There are utilities such as DBMS_REPAIR for fixing corrupt blocks.
> http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76956/repair.htm#8600
Ok, found the equivalent doc for 9i on my doc cd.

Thanks a lot!
Volker

--
While it is a known fact that programmers
never make mistakes, it is still a good idea
to humor the users by checking for errors at
critical points in your program.
-Robert D. Schneider, "Optimizing INFORMIX
 Applications"