Re: LOB maximum data size

Hi,

Fusheng Wang wrote:
>
> Oracle 8i said the maximum LOB data is 2GB. Is that the maximum size of
> one LOB record or the size of all LOB objects in one table? Thanks a lot!

According to the O8.1.5 online help, [B|C|NC]LOB is limited (?!) to 4Gb for one column. You can have as many as 1000 columns of this type per table.

HTH,
Christophe

Christophe L. Galerne                       cgalerne_at_tumbleweed.com
Software Engineer                               Tel: (650) 216 2029
"Nos gueules de bois se dissipent en 24 heures, pas nos conneries."
                                                    - Frederic Dard