Re: HELP! Corrupted data block!

From: R.Schierbeek <bytelife_at_worldonline.nl>
Date: Tue, 15 Sep 1998 22:19:38 +0200
Message-ID: <6tmh66$ksr$1@news.worldonline.nl>

Hello Tim,
A corrupt block could be due to a faulty disk. Rename your table to "corrupt" then you will know where the corrupt stop is.   ( sql> rename <table> to corrupt ; )
Then import the backup table.

Good luck,

       roelof

---

Roelof Schierbeek, DBA
Bytelife BV
The Hague, Holland
email: bytelife AT worldonline.nl
check out : http://home.worldonline.nl/~bytelife

Tim Palmer heeft geschreven in bericht <35FE47D7.FDE02A3_at_cairo.nl>...
>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.
Received on Tue Sep 15 1998 - 15:19:38 CDT