How to get rid of currupt blocks in free space?
Hello,
I have a datafile of 32 GB size. dbverify shows that some blocks inside the datafile are corrupt.
Luckily the corrupt blocks are located in free space and not data segments. I wanted the corrupt
blocks to be reinitialized so dbverify will report the data file as ok. My idea is to create a dummy
table, allocate extents to this table in this datafile until the corrupt blocks belong to this table and
then enter many dummy rows into the dummy table.
Unfortunately after some time I always get ORA-1653 errors, although there is still plenty of free space
in the datafile left:
Luckily the corrupt blocks are located in free space and not data segments. I wanted the corrupt
blocks to be reinitialized so dbverify will report the data file as ok. My idea is to create a dummy
table, allocate extents to this table in this datafile until the corrupt blocks belong to this table and
then enter many dummy rows into the dummy table.
Unfortunately after some time I always get ORA-1653 errors, although there is still plenty of free space
in the datafile left:
0