Hi,
I've find a fractured block in my Oracle database:
SQL> select * from V$DATABASE_BLOCK_CORRUPTION;
FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# CORRUPTIO
---------- ---------- ---------- ------------------ ---------
50 379385 1 0 FRACTURED
I've find that was a Z table on this block.. a table with several deleted recods, so I export/import this table. Now:
SQL> select * from dba_extents where block_id=379385 and file_id=50;
no rows selected
So, how can I mark it as "unusable" block?
Thank you,