Block corruption in blocks with no object- Empty block
Knowing that oracle always reformats empty (here previously deleted) blocks before writing to it, a dummy table was created to (re)write any available block of the tablespace until a tablespace extension error occurs (do review the dedicated tablespace settings in advance):
1
| create table reformat_me tablespace TEXT_DATIDX as select * from all_objects; |
Repeat until the tablespace extension error:
1
2
3
4
5
6
| insert into reformat_me select * from reformat_me;commit;...ORA-1653: unable to extend table reformat_me by 128 in tablespace TEXT_DATIDX |
Execute another dbv based check:
drop the temporary object
check again :)
Cheers!!