Re: corrupt block identification

From: Daniel <nospam_at_nospam.com>
Date: Fri, 21 May 1999 14:08:08 +0100
Message-ID: <7i3lgj$jkd$1@inet16.us.oracle.com>

How did you discover the block corruption?

Ora: 1578 ???

If this exists in a table do a full table scan, if in an index do an analyze cascade ...

--
The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation.

Daniel

rbbdsb wrote in message <7i3k22$cia$1_at_autumn.news.rcn.net>...
>Hi,
>What is the accepted tool for pinning down block corruption. We've been
>using a combination of exports to /dev/null, dbverify, and analyze table
>validate structure cascade. We believe the export doesn't examine the
white
>space portion of the blocks, and the dbverify frequently fails to catch
>corrupt blocks identified by the export. What are other people using?
>
>
Received on Fri May 21 1999 - 08:08:08 CDT