Find the rowid containing a corrupt lob (having the blockid of the corrupted block and the file numb

Good morning,

Oracle 11gr2 11.2.0.3

AIX 5.3

We have a corrupt block in our database, and we have the following information about it:

OWNER                          SEGMENT_TYPE       SEGMENT_NAME                   PARTITION_NAME                  FILE#     CORR_START_BLOCK# CORR_END_BLOCK# BLOCKS_CORRUPTED DESCRIPTION

------------------------------ ------------------ ------------------------------ ------------------------------ ---------- ----------------- --------------- ---------------- --------------

owner                          LOBSEGMENT         A_LOB                                                          538        1120147           1120147         1

We are trying to find out the row(s) that have this corrupt block.

We have executed the following plsql without any success.

declare

  error_1578 exception;

  error_1555 exception;

  error_22922 exception;

  pragma exception_init(error_1578,-1578);

  pragma exception_init(error_1555,-1555);

  pragma exception_init(error_22922,-22922);

  n number;

begin

  for cursor_lob in (select rowid r, col_with_lob from owner.table_with_lob) loop