select v.segment_name,v.extents,v.max_extents
from dba_segments v
where v.segment_name='<my lob segment>' and v.segment_type =
'LOBSEGMENT'
If figures are equal then your segment is unable to get new extents
allocated because it's already reached the max.
May explain.
If you don't specify maxextents while creating your objet, a default
valueusually large enough is used.
You can alter the table your LOB is with alter table <table> modify lob
(<column>) (storage maxextents unlimited)
HTH
--
SL
Received on Thu Dec 08 2005 - 11:05:34 CST
