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