V7.1.5 Phantom corrupt block error

From: <gerardoconnell_at_my-dejanews.com>
Date: Tue, 29 Sep 1998 06:27:48 GMT
Message-ID: <6upul4$an3$1@nnrp1.dejanews.com>

Hi,

My application developers are reporting an intermittant "data block corrupt" error on my V7.1.5 database.

When I investigate the block error disappears. I can retrieve data from the table that the RDBMS thinks is using the "corrupt block". Oracle have analysed ,and given a clean bill of health, to a dump of the block referenced in the .TRC file

The problem seems to become more frequent when one of the developers is inserting across a database link using the following simple code

insert into remote_table_at_remote_sid select * from local_table;

The error message is :
"ORA-01578: ORACLE data block corrupted (file # , block # )"

Any help will be appreciated

Gerard O'Connell

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Sep 29 1998 - 01:27:48 CDT