RE: ORA-01691: unable to extend lob segment ELI.SYS

From: Liu, Jack <jliu_at_atla.com>
Date: Tue, 22 Jul 2003 14:16:42 -0500
Message-Id: <25988.338957@fatcity.com>

Jared,
Thanks a lot.
I use 8k block size, so you mean 100358 is block number and I need total about 781Mb free space?
I have about 300Mb free space for DATA2.

Here is some info about this lob segment: select segment_name, tablespace_name,segment_type, bytes,extents,initial_extent, next_extent, min_extents,max_extents from dba_segments
where tablespace_name ='DATA2'
and segment_name = 'SYS_LOB0000025110C00002$$';

SEGMENT_NAME

TABLESPACE_NAME                SEGMENT_TYPE            BYTES    EXTENTS
------------------------------ ------------------ ---------- ----------

INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS -------------- ----------- ----------- ----------- SYS_LOB0000025110C00002$$

DATA2                          LOBSEGMENT         1677713408         14
      41943040   822132736           1         200

Thanks.

Jack

-----Original Message-----
From: Jared.Still_at_radisys.com [mailto:Jared.Still_at_radisys.com] Sent: Tuesday, July 22, 2003 2:50 PM
To: Multiple recipients of list ORACLE-L Subject: Re: ORA-01691: unable to extend lob segment ELI.SYS_LOB0000025110C000 Assuming an 8k block size, that's 781 meg or so.

Did you allocate enough space for that?

Jared

"Liu, Jack" <jliu_at_atla.com>
Sent by: ml-errors_at_fatcity.com
07/22/2003 12:24 PM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        ORA-01691: unable to extend lob segment

ELI.SYS_LOB0000025110C000 Hi,
I got this error when process blob file: ORA-01691: unable to extend lob segment ELI.SYS_LOB0000025110C00002$$ by 100358 in tablespace DATA2
I added new data file for DATA2, but still the same error. Please help!

Thanks,

Jack
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Liu, Jack
INET: jliu_at_atla.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: Jared.Still_at_radisys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

RE: ORA-01691: unable to extend lob segment ELI.SYS_LOB0000025110