Skip to Content
0
Jul 23, 2016 at 01:40 PM

FRACTURED block

116 Views

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,