Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> 36 first bytes of a lob: meaning ?

36 first bytes of a lob: meaning ?

From: Spendius <spendius_at_muchomail.com>
Date: 2 Sep 2006 01:19:32 -0700
Message-ID: <1157185172.906395.34960@m79g2000cwm.googlegroups.com>


Hi,
I've noticed when you do a block dump that there are 36 extra bytes at the beginning of a lob field (and the length of the lob returned by DBMS_LOB.GETLENGTH substracts these 36 bytes from its result), even if it's empty, so the length shown in a trace file is always length of data + 36.
Someone knows what these byte are about ? Does it depend on the block size ?

Thanks.
Spendius Received on Sat Sep 02 2006 - 03:19:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US