Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: V7.1.5 Phantom corrupt block error
Hi !
Look at your indexes. May be, the corrupt block is an index block. So your error appears only in case of index-using. You should recreate your indexes.
Regards,
Reiner Neumann, Deutsche Messe AG Hannover
gerardoconnell_at_my-dejanews.com schrieb in Nachricht
<6upul4$an3$1_at_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 - 02:27:39 CDT