RE: From row to datafile

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Fri, 6 Aug 2004 14:52:37 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D60E9AE6C0@EXCHMN3>

Thanks Scott and Riyaj. Now a really simple stupid question - How can I dump the lob index??

I can find the index through the dba_lobs column. But I'm wandering around in the dark here trying to figure out how to dump the index. Can anyone help me? Thanks.

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

-----Original Message-----
From: Scott [mailto:oraracdba_at_yahoo.com] Sent: Thursday, August 05, 2004 5:20 PM
To: oracle-l_at_freelists.org
Cc: DENNIS WILLIAMS
Subject: 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

DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote:

> 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

Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
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 Fri Aug 06 2004 - 14:53:13 CDT