Re: 8.1.7.4 - Linux - Tablespace Issue

> 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)

thanks - i did not set the maxextents when i created this tablespace and it seems that is/was the issue - I 'fixed' it by recreating the tablespace and then importing the data but that was a hack

will look into your 'fix' to allow me to do it more elegently next time

thanks Received on Wed Dec 14 2005 - 05:04:59 CST