Re: HELP! Corrupted data block!

Tip: Drop indexes and then try to use TRUNCATE to remove the table data. Hint: I had several ORA-1578 in the last 1 1/2 years. ORACLE Support told me that it is probably caused by the disk controller. They encoutered problems especially with RAID-Controllers !?
Opinion: Today I think, that the problem came from migration between ORACLE versions without importing / exporting the database !? From:MentzerS_at_swissonline.ch

Tim Palmer wrote:

> Can anyone help here?!!
>
> We have a recurrent ORA- 01578 error relating to a corrupted data block.
> We have isolated the segment that is affected (it is a table).
>
> We have a consistent and up to date copy of this table in an export file
> - but attempts to drop the table and re-create it via this import method
> - fail. Dropping the table yields the ORA-01578 error.
>
> We have also tried to retrieve the intact data in the table by forcing a
> full table scan (using its unique index in a hint) and where rowid not
> like ||'.%.'|| (this is from an oracle magazine tech support paper).
>
> Dropping, describing, selecting from..whatever, always yields the
> ORA-01578.
>
> If we can drop the table then we would be ok I think.
>
> Any suggestions, more than gladly received!!!
>
> Tim
Received on Thu Sep 17 1998 - 09:48:56 CDT