| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP! Corrupted data block!
On Tue, 15 Sep 1998 12:56:23 +0200, Tim Palmer wrote
(in message <35FE47D7.FDE02A3_at_cairo.nl>):
>
> 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).
> 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
Hi Jim,
you can select the data using rowid < x and a select rowid > x + #corrupted blocks. You know th damaged block so you can calculate the max rowid that's still valid. Skip the rows in the bad block and select the rest. Can you rebuild the tablespace ? In that case I would export the good tables and import them in a newly created TS and add the resqued rows in it again. With a little luck you can find the damaged rows in your export file.
cheers !
--
Ronald
 |
 |