Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: From row to datafile
Dennis, The last 10 bytes 00 00 00 01 00 00 00 01 00
00 00 0c 08 3b is the lobid and the key into the lob
index. This is not a rdba or a dba so that is why your
query won't work. You will have to dump the lob index
to retrieve the rdba where the actual lob is located.
You will need will need to look through the lob index
dump for column value that contains the lobid and
above that value you will see a another 32 byte value
and the 17th-20th bytes are the RDBA for the LOB
segment.
Hope this helps,
Scott
> Thanks everyone, especially Riyaj and Ian. I really
> appreciate the hard
> work.
>
> Riyaj
> I tried to follow your method and seemed to be
> successful until I got
> down to the last step. I found the block and record
> of the main table. I
> dumped the block of the main table and got the
> following for the 35th record
> in the trace file:
>
> tab 0, row 35, @0x3219
> tl: 96 fb: --H-FL-- lb: 0x0 cc: 9
> col 0: [ 4] c3 4b 5c 0b
> col 1: [ 4] 6b 65 79 31
> col 2: [32]
> 64 38 37 66 33 36 61 30 64 66 32 33 31 38 37 31 35
> 61 39 65 38 66 34 62 35
> 37 65 62 35 62 37 32
> col 3: [ 3] 4d 44 35
> col 4: [ 3] c2 04 19
> col 5: [ 3] c2 03 35
> col 6: [20] 00 54 00 01 01 08 00 00 00 01 00 00 00
> 01 00 00 00 0c 08 3b
> col 7: [ 7] 78 68 08 05 0c 1e 33
> col 8: [ 8] 55 50 44 5f 55 53 45 52
> tab 0, row 36, @0x31b9
>
> However, when I convert c083b to decimal I get
> 788539. I plug that into your
> SQL query for the dba and recieve for file number .
> . . . 0! Can you spot
> where I've gotten off the path? Again, thanks for
> all your help.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
>
> "We all want progress, but if you're on the wrong
> road, progress means
> doing an about-turn and walking back to the right
> road; in that case,
> the man who turns back soonest is the most
> progressive."
> -- C.S. Lewis
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Aug 05 2004 - 17:15:30 CDT
![]() |
![]() |