Dump the block to see if it's a hard or soft corruption.
A hard corruption is when some kind of "stray write" has hit the block, causing one of many checks against eg the rows to fail.
A soft corruption happens when Oracle decides it doesn't have faith in the block anymore, so better corrupt it by zero'ing out part of the footer field.
There's no easy way to tell whether it's a hard or soft corruption. You can dump the block and study the header and footer fields to see if they match. If not, it's probably a soft corruption.
Or get Peter Gram to look at such stuff. He's crazy.
Mogens
Nguyen, David M wrote:
I got ORA-01578 error while querrying info for below table. How do I fix this error?
SQL>Select count(*) from GATEWAYCALLSTATS;
*
ERROR at line 2:
ORA-01578: ORACLE* data block corrupted* (file # 3, block # 2683299)
ORA-01110: data file 3: '/apps/oracle/oradata/SIDB/rtesvr01.dbf'
Thanks,
David
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
