By default, LOB store in line or out of line?

From: Leyi Kamus Zhang <kamusis_at_gmail.com>
Date: Sat, 21 Apr 2012 23:34:01 +0800
Message-ID: <CAPtFpropLPzJ3Vb3PrXm_hLV6gOsBVsfqtmOZfLeFnKke=3hcQ_at_mail.gmail.com>

Hi Lists
According to the Doc as below:
*Oracle® Database Application Developer's Guide - Large Objects
10g Release 2 (10.2)*
Part Number B14249-01

In Chapter 4 there are 2 graph：
1. LOB values are stored out-of-line when any of the following situations apply:

*By default. That is, if you do not specify a LOB parameter for the LOB
storage clause when you create the table.*

2. ENABLE or DISABLE STORAGE IN ROW Clause

You use the ENABLE | DISABLE STORAGE IN ROW clause to indicate whether the LOB should be stored inline (in the row) or out-of-line.

Note:
You may not alter this specification once you have made it: if you ENABLE STORAGE IN ROW, then you cannot alter it to DISABLE STORAGE IN ROW and vice versa.
*The default is ENABLE STORAGE IN ROW.*

Document error? Which one is the TRUTH? or I misunderstanding something?

Based on our test, even every LOB has only 2080bytes(less than 4000bytes), LOB is stored OUT of line, but dba_lobs.in_row=YES.

--
Kamus <kamusis_at_gmail.com>

Visit my blog for more : http://www.dbform.com
Join ACOUG: http://www.acoug.org

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Apr 21 2012 - 10:34:01 CDT