Re: Incorrect Migrated/Chained rows...

From: MAK <maks70_at_comcast.net>
Date: 29 Apr 2004 18:54:21 -0700
Message-ID: <b7178504.0404291754.796b6b60@posting.google.com>

( How do I translate this to restricted
> or extended rowid? ) .

OK I found the way. following sql will give that

select dbms_utility.data_block_address_file(to_number('&&hex_dba', 'xxxxxxxxxxxx')) fno,

dbms_utility.data_block_address_block(to_number('&&hex_dba', 'xxxxxxxxxxxx')) bno
from dual
/

And I got

FNO BNO
---------- ----------

71 4927

So dumped that block and found 2nd row piece there. Row 0 is the fragmented piece.

tab 0, row 0, @0x1f0a
tl: 78 fb: -----L-- lb: 0x0 cc: 43
tab 0, row 1, @0x1ce1
tl: 553 fb: --H-F--- lb: 0x0 cc: 255
nrid: 0x11c0133f.2
tab 0, row 2, @0x1c92 Received on Thu Apr 29 2004 - 20:54:21 CDT