Hello Don It is much easier to use seg/obj. Convert 1441f to decimal and it is 82975. seg/obj: 0x1441f csc: 0x06.8098c3ed itc: 10 flg: E typ: 1 - DATA select owner, object_name, object_type, subobject_name from dba_objects where data_object_id=82975 or object_id=82975; You can also use dba : Block header dump: 0x0404ead5 converting 0x0404ead5 to decimal : 67431125 1 select 2 dbms_utility.DATA_BLOCK_ADDRESS_FILE(&&dba)||','|| 3 dbms_utility.DATA_BLOCK_ADDRESS_BLOCK(&&dba) 4* from dual / DBMS_UTILITY.DATA_BLOCK_ADDRESS_FILE(67431125)||','||DBMS_UTILITY.DATA_BLOCK_ADD -------------------------------------------------------------------------------- 16,322261 -- Cheers Riyaj Shamsudeen Principal DBA, Ora!nternals - http://www.orainternals.com Specialists in Performance, Recovery and EBS11i Blog: http://orainternals.wordpress.com On Mon, Jan 19, 2009 at 11:13 AM, Don Granaman <DonGranaman@xxxxxxxxxxxxxxx>wrote: > After running 'analyze table SCAN_RUN validate structure cascade online, > a trace file showed: > > row not found in index tsn: 20 rdba: 0x0500428c > env: (scn: 0x0006.8098c3d5 xid: 0x0013.002.00067ca1 uba: > 0x0114f97a.e761.33 statement num=0 parent xid: xid: > 0x0000.000.00000000 scn: 0x0006.63cdc395 8sch: scn: 0x0000.00000000) > col 0; len 3; (3): c2 30 5e > col 1; len 6; (6): 04 04 ea d5 00 1d > Block header dump: 0x0404ead5 > Object id on Block? Y > seg/obj: 0x1441f csc: 0x06.8098c3ed itc: 10 flg: E typ: 1 - DATA > brn: 0 bdba: 0x404e08b ver: 0x01 opc: 0 > inc: 0 exflg: 0 > > Supposedly, the rdba can be translated to a file# and block to get the > affected segment name via: > > SELECT owner, segment_name, segment_type > from sys.dba_extents where file_id= &FILENO > and &BLOCKNO between block_id and block_id+blocks-1; > > So, how can I translate the rdba to file# and block#? > > Don Granaman > Senior Database Architect > Solutionary, Inc. > > >