RE: Identifying the content of a corrupted block in system tablespace

Something about 8.0.6 rings bells. If I recall correctly there is a patch to fix an error in block checking, or maybe it was that the upgrade from 8.0.5 to 8.0.6 made block checking catch some good blocks as if they were bad. IF that is the problem and the dictionary block is not actually corrupt you may be able to get all your stuff by turning block checking off. Did someone recently turn block checking on, or start using new data or index types recently?

Otherwise, what the other folks said.

mwf

-----Original Message-----
<snip>
BTW, this is 8.0.6, they identified this problem 3 months ago in their Peoplesoft application, and of course they don't have a good backup from which to recover...

Vlado Barun, M.Sc.

Mobile: 865 335 7652

AIM: vbarun2

--
http://www.freelists.org/webpage/oracle-l