Oracle Database Discussions

Hi,

Environment:-
##########
Oralce 10.2.0
Windows platform
##########

I am facing problem of Logical block corruption.
RMAN validate block corruption (DBVerify as well) But no entry in Alert log file.

When I check Which segment has block corruption I found that block corruption are in free blocks of tablespace (DBA_FREE_SPACE).

To Fix it I create table and allocate corrupted block to that table. I confirm corrupted block allocation in table (using DBA_EXTENTS).

But when I insert rows in that table to reuse corrupted block Oracle give error of ora-1578 Block corruption, and I am not able to reuse corrupted block(as many expert suggest to overcome block corruption in free space).

I dropped table and recreate and repeat this process many times but still no success.

So. can anybody help me on this.

I appreciate your efforts and time you spend to read this

Thanks