Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Corrupted file
I do not think that you need to worry about blocks within free,
unallocated, extents showing as corrupted because when Oracle allocates an
extent to a table or index every block in the extent is re-formatted for
that object. Until being reallocated I believe that free extent blocks
contain whatever garbage used to be in them.
broder_at_my-dejanews.com wrote in article
<6uta9n$a2r$1_at_nnrp1.dejanews.com>...
> I have repaired some database corruptions - however dbv still shows
> some file corruptions even though the blocks with the file are marked
> as free space. We are worried that Oracle might try to reuse these
> free blocks and end up corrupting another table. We plan to try and
> reduce the chances of this happening by using up the free block around
> the corrupted block by dummy tables - the alternative would be a
> lengthy export/import of the affected tablespaces.
>
> Any ideas ??
>
> Cheers !
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
Received on Wed Sep 30 1998 - 08:50:47 CDT