The next_extent size on SYS_LOB0000025110C00002$$ is about 800 meg.
Change the next_extent size to something smaller. RTFM on 'alter table'
if needed.
If you're using LMT's, then the minimum size to allocate is whatever the
uniform size
is on that tablespace, assuming it's been set up with uniform size.
Jared
"Liu, Jack" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/22/2003 01:14 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: ORA-01691: unable to extend lob segment
ELI.SYS_LOB0000025110
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-----
Sent: Tuesday, July 22, 2003 2:50 PM
To: Multiple recipients of list ORACLE-L
ELI.SYS_LOB0000025110C000
Assuming an 8k block size, that's 781 meg or so.
Did you allocate enough space for that?
Jared
"Liu, Jack" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/22/2003 12:24 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Liu, Jack
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
