Run this script and it will tell you what the object is that is corrupt. Hopefully it's an index and you can just drop it and recreate it. If it's a table then there are a couple of things you can do to fix it.
/* title: Corrupt_blocks
purpose:This script will find what objects are corrupt if you receive a datablock corruption error
example: ORA-01578: ORACLE data block corrupted (file # 347, block # 13591)
ORA-01110: data file 347: '/u006/oradata/OARPTSdata4/applsysx03.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option
*/
select segment_name,segment_type,owner
from sys.dba_extents
where file_id=(m)
and (z) between block_id and block_id + blocks -1;
/* note! (m) is the file number and (z) is the block number reported in the ora-01578 error message.
*/
Last edited by OracleDoc; 10-09-2003 at 09:02 AM.
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
Reply With Quote