Mystery "unable to extend" error

From: Janine Sisk <>
Date: Fri, 30 May 2008 13:51:47 -0700
Message-Id: <>

This is an old 8.1.7 installation on Linux, which suffers from the "2 GB per file" problem. A file upload started giving "ORA-01691: unable to extend lob segment" errors so I added another data file to the tablespace, but inexplicably (to me) the errors continue.

There is now plenty of free space in the tablespace:

Tablespace Name Total Bytes Used Free %Used

---------------- ------------------ --------------- ----------------  
USER_LOB          17,112,760,320  14,613,618,688    2,499,141,632   85.4

And yet..

error in `OCILobWrite ()': ORA-01691: unable to extend lob segment USER.SYS_LOB0000041854C00017$$ by 599124 in tablespace USER_LOB

(where I have replaced the actual user name with USER)

I have never seen this before; adding another data file has always been the solution in the past. I don't even know where to look next. Any suggestions?



Janine Sisk
President/CEO of furfly, LLC

Received on Fri May 30 2008 - 15:51:47 CDT

Original text of this message