LOB - DISABLE STORAGE IN ROW ?

[Ed]

create table my_lob_table(f1 int primary key, f2 clob);

If I know most ("> 80%) of the CLOBs persisted will be bigger than 4K
should I just specify "DISABLE STORAGE IN ROW" in the creation ?

thanks

10gR2

[Mark D Powell]

I would disable storage in the row if the LOB data is not retrieved in
the great majority of cases or if it data beyond 4K is normally
retrieved when the LOB is accessed.

For the most part I always want the entire LOB to be stored external
to the table.

HTH -- Mark D Powell --